Print UserForm?

M

Mark A. Sam

Charlote,

DoCmd.PrintOut , 1, 1, acHigh, 1, True

This says print the form from page 1 to 1 print quality High, print 1 copy
and collate.

God Bless,

Mark A. Sam
 
M

Mark A. Sam

Sorry Charlotte,

I thought this was an Access group. I didn't notice it was Excel.
Disregard my previous response.

God Bless,

Mark A. Sam
 
C

Charlotte E

Is it possible to print a UserForm from VBA?

Okey...

I found the way: Me.PrintForm (Simple :)

But, a little too simple!

It just starts printing - I would like it to ask for a printer and also give
the option to cancel.

For some reason, I can't get...

Application.Dialogs(xlDialogPrinterSetup).Show

....to work within a form???


Anyone?

TIA,
 
D

Dave Peterson

Maybe add a button to the userform for printing and then have it do:

Me.PrintForm
 
T

Tom Hutchins

The easiest way is the PrintForm command:
UserForm1.PrintForm

From code within (behind?) the form itself, you can use
Me.PrintForm

Hope this helps,

Hutch
 
Top