Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 13: Introducing UserForms > Toolbox Controls
Toolbox Controls
In the sections that follow, I briefly describe the controls available to you in the Toolbox.
Figure 13-3 shows a UserForm with one of each control. This workbook, named all userform controls.xlsm, is available on the companion CD-ROM.
FIGURE 13-3: This UserForm has one of each of the 15 controls.
Your UserForms can also use other ActiveX controls. See “Customizing the Toolbox,” later in this chapter.
CheckBox
A CheckBox control is useful for getting a binary choice: yes or no, true or false, on or off, and so on. When a CheckBox is checked, it has a value of True; when it's not checked, the CheckBox value is False.
ComboBox
A ComboBox control presents a list of items in a drop-down box and displays only one item at a time. Unlike a