Use VBA to screenshot completed userform and attac

2020-04-16 18:32发布

The title hopefully says it all...

I have a userform named UserForm1 with a command button named SubmitCommandButton

I want to be able to complete all the fields on the userform, click the SubmitCommandButton and automatically have a screenshot of ONLY the userform saved as an attachment to a pre-defined email. I'm not sure how to go about getting this accomplished in the simplest way possible. I can create the email no problem, but getting the screenshot of the completed userform and getting it saved as an attachment, I cannot seem to figure out.

Your expertise is greatly appreciated!!

0条回答
登录 后发表回答