Printing a Userform
 

I need to print a userform that I created.
I've tried using the Userform.Printform statement but it prints to the last
printer that I used.

Is there any way to get the printing preferences box to come up so that I
select which printer to print to?

Thanks for your help!

Printing a Userform
 

Application.Dialogs(xlDialogPrinterSetup).Show


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=556418

Printing a Userform
 

Thanks but I've tried it.
Excel still defaults to the last printer I used.

"kev_06" wrote:


Application.Dialogs(xlDialogPrinterSetup).Show


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=556418