How do you invoke a user form in Excel - Thanks

[WantsToLearn]

I have begun reading about user forms in Excel. How do you invoke them and what are the best ways to set them up?

Thank you!

 

[xlbo]

To invoke a userform, you either need to be in the Visual Basic Editor and have a form that has already been deigned. Make sure the form has the focus and then press the PLAY button OR attach
FormName.show
to a button or an event in a worksheet

Best ways to set them up......very general - depends on what you want them to do. If you are asking how to build them, just go to the VBE , Insert>UserForm and then drag and drop controls onto the form and have a play around with the properties etc

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[WantsToLearn]

Thanks a lot! That is very helpful. The piece I was looking for was formname.show. Have a good day!