Microsoft Office Tutorials and References
In Depth Information
Using the List Box Control
After your INDEX formulas are in place, you have a clean staging table that you can use to create your
chart (see Figure 12-21).
Figure 12-21: A clean staging table to use to create your chart.
Using the List Box Control
The list box control allows users to select from a list of predefined choices. The idea is that when an
item from the list box control is selected, some action is taken with that selection. To add a list box to
your worksheet, follow these steps:
1. Select the Insert drop-down list under the Developer tab.
2. Select the list box Form control.
3. Click the location in your spreadsheet where you want to place your list box.
4. After you drop the control onto your worksheet, right-click the control and select Format
Control.
5. Click the Control tab to see the configuration options, as shown in Figure 12-22.
6. In the Input Range setting, identify the range that holds the predefined items you want to
present as choices in the combo box.
As you can see in Figure 12-22, this list box is filled with region selections.
7. In the Cell Link box, enter the cell where you want the list box to output its value.
By default, a list box control outputs the index number of the selected item. This means that
if the second item on the list is selected, the number 2 will be output. If the fifth item on the
list is selected, the number 5 will be output. Notice in Figure 12-22 that this particular control
outputs to cell P2. The Selection Type setting allows users to choose more than one selection
in the list box. The choices here are Single, Multi, and Extend. Always leave this setting on
Single, as Multi and Extend work only in the VBA environment.
Search JabSto ::




Custom Search