User Form Macro

[fmcc]

I created 10 macros. I would like to now create a user form to call one of the macros.
Two questions:
1. For the user form I would like the user would type the macro name and press OK. Can anyone help me with this?

2. After I have the user form created how do I save the whole thing as an add in to use on any workbook.

 

[Jaye7]

Would they type the macro name into a cell or into a textbox etc... on the userform, you can set up the userform with various buttons so that they don't have to type the name of the macro.

Also which version of excel are you using, helps to know with adding the addin to excel.

 

[fmcc]

I like the button option instead of a text box. This would avoid the user putting in wrong macro name. So the add in will have 10 buttons. Would it be a menu bar with 10 buttons? How do I create this?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

I am using excel 2007.

 

[Jaye7]

In the editor if you look on the second row of the toolbars there is a little toolbox button with a hammer and spanner crossing each other, if you click on it a little box will pop up top left side of the screen, it has various commands available, buttons, listboxes, labels etc... you can click on the command buttons and add them to your form, once on your form you can double click the commandbutton and it will come up with the following.

Private Sub CommandButton1_Click()
 
End Sub

Add your script into the the area between the 2 lines of script and each time someone clicks on it it will run the code, do that for each commandbutton that you add, the help menu in the editor is very useful for other information also, if you want to know more about userforms, commandbuttons etc...

 

[fmcc]

Thanks..