print userform

[peterwmartin]

Hi all,
is there a way to print an vba userform in landscape mode, or to bring up a printer dialogue box before printing it.

I have seen some code on the forum which takes a screen shot, however I worry about the end user getting creative if the see the screen change.

Cheers

[Doug Robbins]

Use Snagit from www.techsmith.com (http://www.techsmith.com) to capture a screen shot of the userform, which you can then either print or copy and paste into a document from the Snagit editor. While you can get a free trial, it is well worth the cost of the application if you have a continuing need for it.

[Dave]

It's either alt+printscreen or ctrl+alt+printscreen that will copy the active userform image to the clipboard. HTH. Dave