Excel 2019 Bible

Chapter 45: Using UserForm Controls in a Worksheet

45

FIGURE 45.2

Excel’s two sets of worksheet controls

This chapter focuses exclusively on ActiveX controls. If the Developer tab isn’t displayed in the Ribbon, right-click
any Ribbon control and select Customize the Ribbon from the shortcut menu. The Customize Ribbon tab of the Excel
Options dialog box appears. In the list box on the right, place a check mark next to Developer. Click OK to return to
Excel.

Table 45.1 describes the ActiveX controls.

TA B L E 4 5.1 ActiveX Controls

Button What It Does

Command

Button

Inserts a CommandButton control (a clickable button).

Combo Box Inserts a ComboBox control (a drop-down list).

Check Box Inserts a CheckBox control (to control Boolean options).

List Box Inserts a ListBox control (to allow the user to select an item from a list).

Tex t Box Inserts a TextBox control (to allow the user to type text).

Scroll Bar Inserts a ScrollBar control (to specify a value by dragging a bar).

Spin Button Inserts a SpinButton control (to increment a value by clicking up or

down).

Continues