O'Reilly logo

Excel® 2010 Bible by John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 42. Using UserForm Controls in a Worksheet

IN THIS CHAPTER

Why use controls on a worksheet?

Using controls

The Controls Toolbox controls

Chapter 41 presents an introduction to UserForms. If you like the idea of using dialog box controls — but 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.

42.1. 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 FALSE.

Figure 42.1 shows an example that uses three types of controls: a Checkbox, two sets of OptionButtons, and a ScrollBar.

NOTE

This workbook is available on the companion CD-ROM. The file is named mortgage loan.xlsm.

Figure 42.1. This worksheet uses UserForm controls.

Adding controls to a worksheet can be a bit confusing because Excel ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required