Printing a userform - Not working

Hello All,

Im trying to do something here I cant quite figure out. Im trying to add a print button to a userform. But three things that have to happen when the button is clicked:
1. Excel has to tell the print dialogue box to ensure the page will only fit on one page by one page
2. The print dialogue box has to pop up so the user can ensure the settings of the print
3. Right now when the print happens scroll bars are printing from the userform. I need those to disappear

This code in its current state is messing with me, it appears I set it to one page by one page but yet when the print happens its only printing the last part of my userform. And right now it also does trigger the dialogue box so that part is solved. I just cant figure out why its not resizing to one page by one page. Any thoughts?

Code:

Please Login or Register  to view this content.

hmm, well I could play with that process. Thanks for the idea! Let me ask this:

I can get Excel to do what I need it to do with that code...I actually got the whole thing to print on one page by two paegs. But as soon as I adjust to 1 page by 1 page thats when it cuts the form....Is there any way to fix that? If not I will just play with the whole transferring the data to a sheet and setting the print area.

Originally Posted by Norie

There's not an lot you can do to control how a userform is posted, they don't even have a PageSetup property/method.

Usually it's better to transfer the data to a (temporary?) sheet and then print that.