How to print entire UserForm?

[bimmerman]

Please Login or Register  to view this content.

This code only prints the visible part of the form, how do I make it so it prints the entire form?

[royUK]

Userforms are not really designed for printing. I would recommend creating a print version on a worksheet to which the input from the UserForm can be saved before printing.

[Leith Ross]

Hello Bimmerman,

This code will copy your UserForm to a temporary worksheet which you can printout. Add a "Print" button to your form, and call the macro to print your form.

Please Login or Register  to view this content.

To Install the Macro:
1. Copy the Macro code above using CTRL+C
2. Open Excel and Right Click on any Sheet Tab
3. Click on View Code in the pop up menu
4. Use ALT+I to activate the VBE Insert Menu
5. Press the letter m to insert a Standard Module
6. Paste the macro code using CTRL+V
7. Save the macro using CTRL+S
8. Close the VBE and return to excel using ALT+Q

Sincerely,
Leith Ross