Printing a UserForm

Hi everyone!

Bit of a tricky one I think, I have a program which will be used by multiple people and at the end, they will need to save a capture of the user form. To save the hassle of forcing them to use the snipping tool, is there a way in which I can use VBA and a command button to save the user form as an image file to the users desktop? Just the form, not just printing the entire screen. I have been doing some reading where others have asked similar questions but nothing seems to have worked thus far.

Please Login or Register  to view this content.

https://www.excelforum.com/showthrea...21540#poststop

Thank you both for your answers. Apologies if I was not clear, as I don't need the form to be physically printed, only to have a PDF of the userform saved.
Is there a way through using VBA to set the default printer to "Print to PDF" for this form?

Thanks Bakerman2, I pasted this code into my userform, however the line

Please Login or Register  to view this content.

appears red as though there is an error, as well as when attempting to run this code by pressing the command button it returns the error "Method 'PasteSpecial' of object '_Worksheet' failed" and highlights the line

Please Login or Register  to view this content.

Any advice?

It seems as though it works fine in the attached file, yet something is wrong in my implementation. Thank you for this though! I will continue playing around and see if I can get it working!

Finally got it working! It seems as though I need to select the userform first before it creates the PDF successfully. Only question now is that the screenshot it creates is just too large to fit on one page, is it possible to scale the PDF down to say 80% original size to fit on one page?

Thank you again very much for all your help!