Printing Userform

[APElliott]

Hello,

Can anyone tell me if & what the code is to print a Userform?

Thankyou,

Andrew

 

[VulcanJedi]

When you goto VB editor, goto file menu, say print. The print menu will prompt to print current module or entire code and there should be a checkbox to print out images of userforms

 

[APElliott]

Cheers,

I can do that!

But the muppets using this form will want a button to do it for them.

Any ideas

 

[VulcanJedi]

You want the end user to be able to print the userform they are currently using?

 

[VulcanJedi]

try userform1.printform (sub with your formname, this seems to just print the body of the userform -- I am sure some settings exist somewhere I am uncertain of, but hopefully this should work for you.
Maybe a 1/2 star?!