In VBA, how to open the standard print dialog box?

I'm sure I have seen the line or two of vba code that opens the standard Office/Excel print dialog box, through which a user can select the printer, number of copies, pages to print, etc, and then start the print run. But so far I can't find the code to do it. Seems like it should be fairly simple. Can anyone show that line (or lines), or point me to the place where I can study up on it and see some sample code. I haven't had any luck with VBA help or the msn forums.

Thanks in advance.

.

Please Login or Register  to view this content.

Thanks Logit (I may have already replied). This is just what I was looking for. I works fine in my app, and is instructive regarding other dialogs.

Glad it helped.

Here's something else for you.