|
1. Select Insert > Form Control > Combo Box from the Spreadsheet Editor menu.
2. Double click in the combo box or select View > Shape Explorer.
3. Set the range address where the selected value from the list will be displayed in the Cell Link text box.
4. In the Input Range text box set the range address that contains the values to be displayed in the list.
5. Set the number of lines to be displayed in the drop down list.
Notes:
· When a value is selected in the list, the linked cell value will change to display the same value.
· Combo box controls will only be saved if you save the workbook file in 97-2003 Excel© format (*.xls)
· To select a combo box control, position the pointer over it and press the right mouse button.
Related topics:
Shape Explorer
.png)
Fig. 1: Combo box control
|