Open a User form by clicking a Button in Excel (VBA)

1. Goto Developers Tab.
2. Click on "Insert"
3. Select Button (Form Control)
4. Right Click on the button created and select "Assign Macro"
5. Give the Macro Name and select OK.
6. Then add the following Macro code:

Sub Button1_Click()

UserForm1.Show

End Sub