How to get back values in the excel bulidin dialogs ?

J

james

I used "Application.Dialogs(xlDialogPrint).Show" to show dialog, but can't
retrun the printset values which user setting. (like range_num, from, to,
copies, ...)
 
J

Jim Cone

You can get back true or false depending on whether ok or cancel was clicked.
But you are out of luck on getting back any other info.

The printout method allows you to specify various settings before printing.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"james"
wrote in message
I used "Application.Dialogs(xlDialogPrint).Show" to show dialog, but can't
retrun the printset values which user setting. (like range_num, from, to,
copies, ...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top