Activation of UserForm?

Re: Activation of UserForm?

jonny,

Using a button on a toolbar is one way of running a macro to display a userform. However, before you do that you first need to create a macro to display the form, e.g.

Sub DisplayForm()
    UserForm1.Show
End Sub

When you have the macro in place, place the Custom Button on your toolbar, click Modify Selection and then Assign Macro.. click on the name of the macro you have created and OK.

Alternatively, if you don't want to create a toobar button, you can run your macro from Tools > Macro > Macros, select your macro name then Run.

However, both options require a macro in a standard code module that has the command to show your userform.

Hope this helps.

Regards,
Batman.

Re: Activation of UserForm?

Yes copy to module 1 if You want and that procedure will kick the USerform1 (if thats the name of the userform of cause) into life and the form will be seen

jiuk