How can I set number of copies using Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a CommandButton to indicate to a user that they can print a selected field.

My question is: How can I add in a feature that allows the user to select the number of copies that they want to print out (say between 1 to 6 copies of the same field)?

Is there a way to have them type in the desired number of pages in a cell (e.g., 6 copies) and then have the Macro pick up on that number and feed it into the Command?
 
Hi David

Sub test()
With ActiveSheet
.PrintOut copies:=.Range("G22").Value
End With
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




David said:
I am using a CommandButton to indicate to a user that they can print a selected field.

My question is: How can I add in a feature that allows the user to select the number of copies that they want to print out
Click to expand...
(say between 1 to 6 copies of the same field)?
Is there a way to have them type in the desired number of pages in a cell (e.g., 6 copies) and then have the Macro pick up on
Click to expand...
that number and feed it into the Command?
 
Back
Top