Print Screen

M

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)
 
B

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
 
M

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
 

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

Similar Threads

Normal Random Variable Generator 3
Query Data from a Sheet 4
Excel VBA - Problem with Closing Print Preview 0
Excel 2007: Print Form Control on a full page graph 2
Changing The "Printing Sheets Per Page" In VBA? 3
Print preview / full screen view problem 2
ComboBox and Set Focus 1
Determining which Print Button was clicked 2

Top