Printing

[Greg B]

I am not sure of what it is but I need the screen where you choose your
printer and print out amounts.

How do I get this to show in a macro?

Thanks in advance

Greg

 

[Myrna Larson]

To to VBA Help and in the Answer Wizard, type in Dialogs Collection Object. In
the resulting Help page there's a link at the bottom reading something like
'built-in dialogs argument lists' that includes all of the dialog names.

 

[Dave Peterson]

Application.Dialogs(xlDialogPrint).Show

And if you had a userform, you could use:

worksheets("sheet1").printout copies:=clng(textbox1.value)

 

[Greg B]

Thank you Dave

Works Great

Greg

Application.Dialogs(xlDialogPrint).Show

And if you had a userform, you could use:

worksheets("sheet1").printout copies:=clng(textbox1.value)