Is it possible to copy userform controls to worksheet?

[trishgyrl]

Hello.

I created a userform but, I decided to just create the form directly on the worksheet.

Is it possible to copy all controls on the form and paste to the worksheet so I won't have to start all over?

 

[Norie]

Sorry but the short answer is no.

 

[Kyle123]

You really don't want to. You're much better off not using ActiveX controls on worksheets - use Forms controls instead

 

[ranman256]

its better to use worksheet FORM controls instead of the ActiveX ones that forms use.
(the names are counter-intuitive)
Form controls work good on the spreadsheet. (not forms, duh.)

 

[trishgyrl]

Okay...just checking. Can I still assign macros to the form controls? Sorry, I am new to this somewhat.

 

[Norie]

You can only assign macros to Forms controls.

 

[trishgyrl]

You can assign them to activeX controls too, right? Or, is it best to not use those on the worksheets?

 

[Norie]

You can't assign macros to ActiveX controls, the only types of controls with the Assign macro... option when you right click are Forms controls.

 

[trishgyrl]

okay I see what you're saying

 

[Eric W]

You can assign a macro to an ActiveX control on a worksheet, but the procedure is different. Right click on it and select "View Code."