Print button to print userform

I added a print button to my userform

Please Login or Register  to view this content.

This prints out the userform as I would like, however it autoprints to the default printer and doesn't allow any printing options so I can't select to "print to one page". So as of now it is only printing out half my form and cutting off the rest.

Any suggestions?

That code will bring up the print options screen, however, none of the changes made in that screen effect the actual output of the print. It is still printing out cutoff

if the trouble you are having is that the userform falls outside the printers range,

You could resizee the form
untested.

Please Login or Register  to view this content.

hope this helps