How to Make a UserForm Appear on Spread Sheet

Video Tutorial Contents

0:13 ]- 3 basic steps to get Form to show up on Spread Sheet

0:47 ]- STEP 1- INSERTTING ( CREATING ) A USER FORM IN VBA EDITOR
1:17 ]- Give UserForm a Name in the Property Sheet
1:29 ]- 2 Rules for giving a name to a UserForm
1:55 ]- Caption Property

2:22 ]- STEP 2 - "MAKE A SUB ROUTINE"
2:28 ]- Create a Module
2:43 ]- Change Module Name
3:03 ]- Create Sub Routine ( also called a "Procedure")
3:31 ]- Command to make UserForm Appear

4:18 ]- STEP 3 - "MAKE A CLICK-ABLE BUTTON"
4:28 ]- Use a Form Button from Developer Tab
4:39 ]- Use a SHAPE from the Shapes menu
4:56 ]- Insert Picture into Shape Button
5:39 ]- Add Words or Text to Shape Button
6:13 ]- Assign sub Routine (Proceedure) to Button

6:46 ]- Closing Remarks, Web Links & Related Tutorials