The print dialog will do the printing - so you would just be repeating what
it has already done (unless you cancel printing in the before print event).
Built in dialogs only return true or false. You can't get user selections
from them.

Perhaps you need to put up your own userform to get this information.

Regards,
Tom Ogilvy


"Wes" wrote in message
...
How do I access the # of copies that a person has chosen
after they hit print on the print dialog box?

My program prints a page several times, making changes to
several values before each print. The program shows the
print dialog box only for the first time, allowing the
user to choose the printer and the number of copies etc.
It then prints the remaining pages.

How do I set NumCopies (in the code below) to the number
of copies the user chose in the print dialog

Application.Dialogs(xlDialogPrint).Show

... some other code ...

ActiveWindow.SelectedSheets.PrintOut Copies:=NumCopies,
Collate:=True

Your help would be greatly appreciated. Thanks.