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!

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!

Hi Bob,

Thanks for the help. I tried, but it only prints the sheet not the form.
What I want is to print the form with all the entries in controls. Any
idea to help?

Best regards

Ming



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

Hi Ming Shao;
You can use Me.PrintForm

MP

"Ming Shao" a écrit dans le message de
...
Hi Bob,

Thanks for the help. I tried, but it only prints the sheet not the form.
What I want is to print the form with all the entries in controls. Any
idea to help?

Best regards

Ming



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