userform.print

[kasack]

Howdy
userform.print
uses the default printer.
I'd like to be able to choose
a different printer.
What do I need to add so that the
userform prints on a printer that I
choose and not the default printer ?
Path ?
node name of the printer ?

Thanks for the help

 

[Derek]

Hi Kasack
Try recording a macro to print the sheet. Go to File, Print and change the name of the printer in the dropdown box to the one you want. Stop recording, then use Alt+F11 to go to the VB Editor and check the code it used.

Hope this helps
regards
Derek

 

[Dave Hawley]

How about

Application.Dialogs(xlDialogPrinterSetup).Show

 

[kasack]

On 2002-04-08 05:58, Dave Hawley wrote:
How about

Application.Dialogs(xlDialogPrinterSetup).Show

Not bad, thats what I do need,
how can I now command to print on a chosen
printer ?

I choose printer 5 , ok, = print
but that method isn't working
thanks anyhow