|
1. Select Insert > Form Control > List Box from the Spreadsheet Editor menu.
2. Double click in the list 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.
Notes:
· When a value is selected in the list, the linked cell value will change to display the same value.
· List box controls will only be saved if you save the workbook file in 97-2003 Excel© format (*.xls)
· To select a list box control, position the pointer over it and press the right mouse button.
Related topics:
Shape Explorer
.png)
Fig. 1: List box control
|