Userform Macro query

[Kelt]

Hi, I have created a userform but now I want to create a macro so when you click on (e.g.a button) it will open the user form, just for ease of use really. Can anyone help.

[Ryan Murtagh]

In your Visual Basic editor, add a standard code module (if you don't already have one in your project) and insert the following code:

Please Login or Register  to view this content.

Substitute "MyNewForm" for the name of your UserForm. Then add a Forms (not ActiveX) Control CommandButton to whichever worksheet from which you wish to launch the form. Right click on the button and select Assign Macro from the context menu. A dialog box should appear with a list of any public macros you may have in your open workbooks. Select Show_My_Form. You should be good to go!