Printing Multipage Excel Userform

[Stuart705]

I have a userform that is used as an inspection report that contains 6 pages. I am not sure how to code directions to print each page individually. The user should be able to save the report as a PDF (to email to the department manager) or print out while at the location. Therefore, the user should be able to choose the printer.

I am able to use .PrintPreview such that the document can be formatted and printer can be chosen, but am not sure how to code such that the header information and each individual page can be printed.

I've attached a sample userform (Book1.xlxm) such that you can see what I am doing and then let me know how to correct. I greatly appreciate your assistance.

Stuart

[Keebellah]

This doesn't work for a userform.
The object does not show, maybe if ShowModal were False but then again I don't think this will give you the result.
Why do you want to print the Userform, why don't you create a worksheet that shows the results a for based upon what you fill or select in your Userform.
You mention 6 pages, the Usefrom only has three extra page tabs
I think you should be a little more explicit with your explanation. maybe show a sample of what you hope to achieve?

[Stuart705]

Let me clarify. I've attached the actual form and it now has four pages. It is better to print a PDF of the form or provide an actual printout of the form and provide that to the department manager. My goal is to do a Print Preview so the user can choose the printer and format the page. Each page should print individually and include the header information (Reviewer, Review Date and Site Name) with each page. I have tried and the form overlays the report. Assistance is appreciated.

[Keebellah]

Good start

Please Login or Register  to view this content.

Doesn't Exist

[Keebellah]

Selecting a printer is default Windows Functionality

The first code returns the printer name to display in a form or on a button

The second macro actually lets you select a printer amongst the available printers on the user's system

Please Login or Register  to view this content.

[Stuart705]

This is great and thank you very much!

Stuart

[Keebellah]

Good to hear, I've got an idea about printing the userform but am working it out.
Me.PrintForm does it if you add a button and make it do that but then you need to make it fit the page