Printing Userform w/ Printer Selection

[ETLahrs]

I am trying to print a userform. I know I can use userform.printform,
however I want to be able to select which printer to print it on. By
default, we have the B&W printer selected, however there is a graph on the
userform that is much more useful when in color. I know about the
Application.Dialogs(xlDialogPrint).Show, but if I set that up to a command
button, it will print the active sheet, not the userform.

Is there anyway to combine the userform.printform and the
Application.Dialogs(xlDialogPrint).Show?

Thanks for the assistance,
Ed

 

[Héctor Miguel]

hi, Ed !

I am trying to print a userform.
I know I can use userform.printform, however I want to be able to select which printer to print it on.
By default, we have the B&W printer selected, however there is a graph on the userform
that is much more useful when in color.
I know about the Application.Dialogs(xlDialogPrint).Show
but if I set that up to a command button, it will print the active sheet, not the userform.
Is there anyway to combine the userform.printform and the Application.Dialogs(xlDialogPrint).Show?

- you could try with the dialog-constant: xlDialogPrinterSetup (prior to your .PrintForm instruction)

- you could try by copy/paste an image of the userform into any worksheet (and delete after print)

hth,
hector.

 

[ETLahrs]

Hector,

I have tried to use the xlDialogPrinterSetup, but that didn't make a
difference. The only way it .printform will work is if I change the default
printer for my computer. Even if I change it in excel, the userform will
still print to whatever the default printer for the computer.

I may have to try the copy/paste and then delete it after.

Thanks.