Print Screen

[Ming Shao]

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

(e-mail address removed)



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

 

[Bob Flanagan]

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]

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!

 

[Michel Pierron]

Hi Ming Shao;
You can use Me.PrintForm

MP