MrExcel.com - Your One Stop for Excel Tips & Solutions

Print of userform on another printer

Posted by Jan on August 16, 2001 12:58 PM

Is it possible in VBA-Excel to change printer to print out a userform?

I use the command Me.Printform to print the userform, but how do I change the printer.
It's easy to change the printer via the ActivePrinter command, but i doesn't work with userforms.

Hop you can help.

Posted by steve w on August 16, 2001 5:33 PM

NOT SURE WHAT YOU WANT

Are you trying to print from a userform or print the userform.
And how do you want to change the printer

steve w

Posted by Jan on August 19, 2001 4:26 PM

Re: NOT SURE WHAT YOU WANT

Hi Steve

Thanks for trying to help!
I try to print the userform from another printer, but i can't change the printer via VBA-code.

Do you now how? The ActivePrinter command doesn't work with printout of userforms.