UserForm Print Preview

I have a user form with a "Print" button with this code

Please Login or Register  to view this content.

The button prints the user form as expected. What I'd like to do is send the user form to "Print Preview" and allow the user to change printers and/or printer options (landscape, portrait, etc.).

I've spent considerable time with Google and haven't found a way to do this. Any help is greatly appreciated.

John

Hello John,

Unfortunately, there does not exist a call in VBA or Excel to do a Print Preview of a UserForm. However, it can be done but is not a simple task, even though it seems like it should be. It involves a lot of heavy API calls to transfer the contents of the UserForm to the Printer in a binary format so that it can be printed out correctly.

I can't really see why you want t oprint a UseForm,nuch better to write the contents to a Form set up on a sheet for printing. You can select the printer by adding

Please Login or Register  to view this content.

Hi Leith
I figured after searching Google for a couple of hours and not finding a hit that there was probably no simple solution. Thanks for your input.

Hi royUK
I had this

Please Login or Register  to view this content.

but it doesn't help with my issue. Thanks for your input.

John

Hello John,

I don't have the time right now to code the API for a Print Preview function, but it would be a interesting project and worthwhile to have. When were looking to add this into your project?

Hi Leith

I'm using

Please Login or Register  to view this content.

currently and this works. I'd like to give the user more control over the print event rather than sending directly to the printer. So, there's no rush. I appreciate your willingness to help.

John

Hello John,

It is a macro that should have been provided in VBA but for what ever reason wasn't. After it is written, I'll post it back in this thread.

Hi Leith

That's very generous of you. Thank you.

John