|
-
Feb 4th, 2010, 08:39 AM
#1
Thread Starter
Junior Member
[RESOLVED] Copy Controls (including formatting) from Worksheet to UserForm
I have a lot of controls (CommandButtons, ListBoxes, Textboxes, Checkboxes, etc.) that are currently in a worksheet. They all have very specific color-coding and size formatting, which I would hate to lose as I am trying to move them to a UserForm created in VB. Is there any way that I can copy them from the Worksheet to a UserForm?
I understand that I could recreate each button, then just copy the code from the various Modules, but it would be incredibly tedious to recreate each button. Thanks.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|