Printing from a dialog box

[lauro]

hello everybody,

I have this worksheet where the data is input from dialog boxes in a form. As the amount for prints vary, is there a way that I can input the amount of copies that I need in a dialog box and link this to a printing macro?

Thanks for your help

[xlnitwit]

Hi,

You can show Excel's own print dialog using a simple line of code:

Please Login or Register  to view this content.

or if you only wish to print one sheet you may specify the Copies argument of the Printout method:

Please Login or Register  to view this content.