Excel 2010 Bible

Chapter 42: Using UserForm Controls in a Worksheet

867

l (^) LinkedCell: The worksheet cell that’s linked to the CheckBox. The cell displays TRUE
if the control is checked or FALSE if the control is not checked.

ComboBox

A ComboBox control is similar to a ListBox control. A ComboBox, however, is a drop-down

box, and it displays only one item at a time. Another difference is that the user may be allowed to

enter a value that does not appear in the list of items.

Figure 42.5 shows a ComboBox control that uses the range D1:D12 for the ListFillRange and

cell A1 for the LinkedCell.

FIGURE 42.5

A ComboBox control.

The following is a description of the most useful properties of a ComboBox control:

l (^) BoundColumn: If the ListFillRange contains multiple columns, this property determines
which column contains the returned value.
l (^) ColumnCount: The number of columns in the list.
l LinkedCell: The worksheet cell that displays the selected item.
l (^) ListFillRange: The worksheet range that contains the list items.
l ListRows: The number of items to display when the list drops down.
l (^) ListStyle: Determines the appearance of the list items.
l Style: Determines whether the control acts like a drop-down list or a ComboBox. A
drop-down list doesn’t allow the user to enter a new value.