Within a self-written VB userform, how do i get the print dialogue box to
open by using a macro attached to a button. The VB macro
[Sheets("sheet1").Printout] only prints to the default printer but won't let
you select a printer to output towards. I want the user to be able to choose
which printer to print to AFTERr pressing my macro print button (akin to
pressing file/print... instead of pressing the print button on the toolbar -
cos these will all be turned off and hidden other than my userform.)

application.Dialogs(xlDialogPrint).Show

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tinkmodbod" wrote in message
...
Within a self-written VB userform, how do i get the print dialogue box to
open by using a macro attached to a button. The VB macro
[Sheets("sheet1").Printout] only prints to the default printer but won't
let
you select a printer to output towards. I want the user to be able to
choose
which printer to print to AFTERr pressing my macro print button (akin to
pressing file/print... instead of pressing the print button on the
toolbar -
cos these will all be turned off and hidden other than my userform.)

Excellent. Works perfectly. Thanks for you prompt reply.

....tinkmodbod



"Bob Phillips" wrote:


application.Dialogs(xlDialogPrint).Show

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tinkmodbod" wrote in message
...
Within a self-written VB userform, how do i get the print dialogue box to
open by using a macro attached to a button. The VB macro
[Sheets("sheet1").Printout] only prints to the default printer but won't
let
you select a printer to output towards. I want the user to be able to
choose
which printer to print to AFTERr pressing my macro print button (akin to
pressing file/print... instead of pressing the print button on the
toolbar -
cos these will all be turned off and hidden other than my userform.)