[RESOLVED] Copy Controls (including formatting) from Worksheet to UserForm

[Cristobal16]

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.

[Siddharth Rout]

Yes you can do it...

Simply drag the control directly from the worksheet and put it into the Userform. See the pic attached. However, you cannot do it vice versa. If you try doing it then the cursor will turn into a "No Cursor" (a circle with a diagonal line through it)

Hope this helps...

[Cristobal16]

Perfect! Thanks Koolsid. I have no clue how you are able to be on here, answering everyone's questions every day, but thanks a lot!

[Siddharth Rout]

Perfect! Thanks Koolsid. I have no clue how you are able to be on here, answering everyone's questions every day, but thanks a lot!

You are welcome. Well, I get to learn lot of things here in VBF... that's why