Have existing button! Can I add existing buttons to New User Form???

[michaelch2934]

Obviously new to VBA. I've created spreadsheet with many buttons and text boxes, etc... Now, I realize I should have placed them on a User Form for better control.

Is this even possible? Can I add existing buttons to a new user form?

I've searched the internet and especially your site for the answer. Seems I've painted myself into a corner, as it were. Any suggestions?

 

[My Aswer Is This]

I would add all new controls to your Userform and then put your existing code into those controls.
You cannot just copy a activex button and paste it into your userform.

Now if all your scripts are Module scripts you could put a call function into your Userform controls to run those script.

For example if your module script is named Hello

In your Userform control you could just enter this line of code:

Call Hello

And the module script named Hello would run.

 

[michaelch2934]

Thanks. I kind'a figured that would be the situation. Guess I learned the hard way how to build a User Form.

 

[My Aswer Is This]

Building a Userform is not that hard. You have all the same sort of controls you can add to the Userform just like Activex controls. Put your control where you want and put your script into the control by double clicking the control.

I'm sure you can figure it out. If you need some help maybe we can give you some help.