|
1. Select Insert > Form Control > Spinner from the Spreadsheet Editor menu.
2. Double click in the spinner control or select View > Shape Explorer.
3. In the Cell Link text box, type the cell address where the scroll value will be displayed
4. Set the scroll minimum and maximum values.
5. Set the scroll small change increment value.
Notes:
· When the spinner value changes, the linked cell value will change accordingly.
· Spinner controls will be saved only if you save the workbook file in 97-2003 Excel© format (*.xls)
· To select a spinner control, position the pointer over it and press the right mouse button.
Related topics:
Shape Explorer
Fig. 1: Spinner control
|
.png){kind=small}