Pages

How to add a userform to Excel

View your visual basic window (Alt+F11). Then with the project that you are working on selected in the project explorer window click:

Insert > UserForm

To view your wonderful new userform click:

Run > Run Sub/UserForm  OR you can press F5

Enjoy