Chapter 41: Using UserForm Controls in a Worksheet
In This Chapter
Understanding why you may want to use controls on a worksheet
Looking at the Controls Toolbox controls
Chapter 40 presents an introduction to UserForms. If you like the idea of using dialog box controls, but you don't like the idea of creating a custom dialog box, this chapter is for you. It explains how to enhance your worksheet with a variety of interactive controls, such as buttons, list boxes, and option buttons.
Why Use Controls on a Worksheet?
The main reason to use controls on a worksheet is to make it easier for the user to provide input. For example, if you create a model that uses one or more input cells, you can create controls to allow the user to select values for the input cells.
Adding controls to a worksheet requires much less effort than creating a dialog box. In addition, you may not have to create any macros because you can link a control to a worksheet cell. For example, if you insert a
CheckBox control on a worksheet, you can link it to a particular cell. When the
CheckBox is checked, the linked cell displays
TRUE. When the
CheckBox is not checked, the linked cell displays
Figure 41.1 shows an example that uses three types of controls: a
Checkbox, two sets of
OptionButtons, and a
ScrollBar. The user's selections are used to display a loan amortization schedule on another worksheet. The workbook is very interactive, but it uses no macros.
This worksheet uses ...