CHAPTER 13
Introducing UserForms

---

IN THIS CHAPTER

• Creating, showing, and unloading UserForms
• Exploring the UserForm controls available to you
• Setting the properties of UserForm controls
• Controlling UserForms with VBA procedures
• Creating a UserForm
• Introducing the types of events relevant to UserForms and controls
• Customizing your control Toolbox
• Going over a handy checklist for creating UserForms

---

How Excel Handles Custom Dialog Boxes

Excel makes creating custom dialog boxes for your applications relatively easy. In fact, you can duplicate the look and feel of many of Excel's dialog boxes. You use a UserForm to create a custom dialog box, and you access UserForms in the Visual Basic Editor (VBE).

This is the typical sequence you'll follow when you create a UserForm:

1. Insert a new UserForm into your workbook's VBA project.
2. Add controls to the UserForm.
3. Adjust some of the properties of the controls that you added.
4. Write event-handler procedures for some of the controls...