MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy / Paste Userform?


Posted by Paul Magruder on June 04, 2001 11:58 AM

Is there a way to Copy a Userform (as it looks in the show mode)to the clipboard. I would like to paste it to Mail Server. I know I can print it...but am having difficulty copying to the clipboard.... Thanks in advance

Paul


Posted by Ron on June 04, 2001 12:26 PM

If the form is running, you can choose Alt & Print Screen to copy it to the clipboard. This will only copy it as an image however. If you need the form itself, you can export the form as a .frm file in the Visual Basic Editor.
Hope that helps.

Posted by Paul Magruder on June 05, 2001 4:54 AM

Thanks... It Helps