call a userform from a button

[hitch_hiker]

I have created a userform called "frmProductList", how can I make this userform show when I press a button, does the button need to be a form or activeX control? subsequently once the userform has done it's job how do I close the userform, ( I'm guessing unload.me )

 

[Trevor G]

Either should work,

Use a Form Button to test it out.

In a module sheet in VBA add in a sub routine like this

Sub ShowFormName()
UserForm.Show
End Sub

Then go back to your worksheet and right click your button and select Assign Macro and use the macro name as above.

Behind your form perhaps on a Command Button for Closing it would be something like this, depending on the name

cmdClose()
Unload Me
End Sub

 

[hitch_hiker]

thanks for that, it's probably very easy once you know how, would be better if excel help actually helped.

 

[Trevor G]

Help does work but sadly you need to know how to use it to the best advantage, aslo you can use the object browser, you would Press F2 it should give you the syntax you need.

However pleased to read you have a solution and thanks for letting me know.