How to get back values in the excel bulidin dialogs ?

[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, ...)

 

[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, ...)