Printing Contents of UserForm

[will]

Hello:

I have a userform in Excel. I have set up a print command button that works
using Userform.printform but it only prints part of the 1st page. I'm ok to
find a solution to make one page print at a time but I at least need the
entire page to print. The form is too long and has a scrollbar to allow users
to see the whole thing on screen. If it helps any, the user form contains a
multipage control which houses the form data.

Thanks!

 

[joel]

I would create a temporary worksheet for printing the data. The macr
you created can copy all the data to a worksheet then print th
worksheet and delete the worksheet at the end. You could make the prin
sheet a hdien worksheet do you don't have to add and delte this shee
every time you want to perform the print