Put a button on the form, double click it to get to the click event code and
then put the following line in the button's click event code:

ActiveWindow.VisibleRange.PrintOut

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Ming Shao" wrote in message
...
Hi

Thanks for the help.

I have another question.

In my Excel application, there is a form with some controls. Users
request to have a button and to print the screen when they click the
button. Does anyone know how to do that?

Thanks

Ming





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!