UserForm copies to clipboard, but includes the MsgBox that pop up, how to prevent this?

Good Day,

Hope you are well.

In the past I always used this code (below) to copy the UserForm that is open to paste in documents presentations etc. However, I am not sure if this was due to the upgrade to MS Office 365 or what, but now it copies the UserForm and the MsgBox to the clipboard as per the attached picture.

My Question is what code should I add or try to prevent the MsgBox from copying to the clipboard as well?

I thank you in advance.

Please Login or Register  to view this content.

UserForm and MsgBox clipboard 1.png

Try copying the screen before you display the message box but if you really want to tell the user it has been done before doing it then possibly add a line between the 2 statement containing just

Please Login or Register  to view this content.

Hi there,

Thanks for the reply, I figured out some other method as well. I put in a delay before the next code runs and it worked. Looks like this.

Please Login or Register  to view this content.

That's exactly what Doevents does - it allows the Operating system to catch up with pending tasks but it still seems more logical to capture the screen before telling the user you've done it.

Hi there,

Just out of interest if I copy the userform before showing the message for, then for some reason it copies my whole screen image and not just the userform. Weird, but at least my work around works now. Thanks!

Thanks for that - might have a look out of curiosity.