How to create a userform in excel.

1. Open your ms excel then go to developer tab and click visual basic editor. if you don't see the developer tab on your ribbon/menu tab,for ms excel 2010/2013 users click this link http://msdn.microsoft.com/en-us/library/bb608625.aspx , and for ms excel 2007 users click this link http://office.microsoft.com/en-us/word-help/show-the-developer-tab-or-run-in-developer-mode-HA010173052.aspx

2. Click Visual Basic Editor or press the shortcut key  alt+F11 to open it
 

3. Click insert on the menu tab then click 'Insert User form'


4. Now that we have a user form, to add controls click on the user form(if the toolbox didn't appear, on the menu tab, click view > select toolbox

 5. Create labels, text box combo box etc.. there are many controls that are useful in there so make use of it

6. To access your user form go back to your ms excel then click on the developer tab > click insert > click the command button > and click to any area of your excel cells




7. Click new, find below picture














8. Put this code. See below pics

9.  Everytime you click the Button1(Command Button) your form will show, find below snapshot:)