Excel® Programming: Your visual blueprint™ for creating interactive spreadsheets

Chapter 14. Creating Dialog Boxes and Customizing the Ribbon

UserForm Basics

Every Windows application uses dialog boxes to gather information from the user, and Excel is no exception. For example, you can use the Open dialog box in Excel to select a file to open. VBA has two ready-made dialog boxes, MsgBox and InputBox, that you can use with your code. In addition, you can create your own custom dialog boxes. See Chapter 7 for more information on the MsgBox and InputBox dialog boxes.

Use the Visual Basic Editor to Create Custom Dialog Boxes

By using the VBE, you can create custom dialog boxes to use with your Excel procedures. The VBE refers to these custom dialog boxes as UserForms. When you create a UserForm, you design it by using the various ...