Printing
 

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

Printing
 

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.

On Thu, 21 Apr 2005 04:43:50 +0930, "Greg B" wrote:

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

Printing
 

Application.Dialogs(xlDialogPrint).Show

And if you had a userform, you could use:

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



Greg B wrote:

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

--

Dave Peterson

Printing
 

Thank you Dave

Works Great

Greg
"Dave Peterson" wrote in message
...
Application.Dialogs(xlDialogPrint).Show

And if you had a userform, you could use:

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



Greg B wrote:

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

--

Dave Peterson