PDA

View Full Version : Center userform using Printform



av8tordude
04-09-2010, 09:47 AM
I'm using
userform1.printformto print a userform. when the form prints, the form get printed in the upper left corner of the page. Is it possible to center the form in the middle of the page when printing?

lucas
04-09-2010, 10:46 AM
I think that would be a printer setting.

It is usually much easier to use a template sheet and transfer all the userform data to it to print. Uses less ink too.

You have complete control over the formatting.