Microsoft Office Tutorials and References
In Depth Information
Using the Combo Box Control
Notice that the formula shown in Figure 12-16 uses absolute references with cell A8.
That is, the reference to cell A8 in the formula is prefixed with $ signs ($A$8). This
ensures that the cell references in the formulas don’t shift when they’re copied down
and across.
Tip
To test that the formula is working fine, you could change the value of cell A8 manually, from 1 to 3.
When the formula works, you simply copy the formula across and down to fill the rest of the staging
table.
When the setup is created, all that’s left to do is create the chart using the staging table. Again, the
major benefits you get from this type of setup are that any formatting changes can be made to
one chart and it’s easy to add another dataset by adding another option button and editing your
formulas.
Using the Combo Box Control
The combo box control allows users to select from a list of predefined options from a drop-down list.
The idea is that when an item from the combo box control is selected, some action is taken with that
selection. To add a combo box to your worksheet, follow these steps:
1. Click the Insert drop-down list under the Developer tab.
2. Select the combo box Form control.
3. Click the location in your spreadsheet where you want to place your combo box.
4. After you drop the control onto your spreadsheet, right-click the control and select Format
Control.
5. Click the Control tab to see the configuration options, as shown in Figure 12-17.
6. In the Input Range setting, identify the range that holds the predefined items you want to
present as choices in the combo box.
7. In the Cell Link box, enter the cell to which you want the combo box to output its value.
A combo 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-17 that this particular control
outputs to cell E15.
8. In the Drop Down Lines box, enter the number of items you want shown at one time. You
see in Figure 12-17 that this control is formatted to show 12 items at one time. This means
when the combo box is expanded, the user sees 12 items.
Search JabSto ::




Custom Search