Come in Spinner !

It is often useful to limit the values that a user can input into your worksheet.

For example, when accepting bets in a gambling worksheet you may wish to limit the bets to multiples of, say, $10.

This can be accomplished by using the Spin control.

The Spin control is also available from the Form Toolbar.

Select the Spin control and drag out an area from C1 to C4.

Double click your Spin control to bring up the Format object Dialog box.

Set the Minimum Value to 10
Set the Maximum Value to 150
Incremental Change to 10
In the Cell Link box enter A1 and press Ok.

Deselect the Spin control by Clicking elsewhere on your worksheet.

Clicking the Spin controls will increase or decrease the value(bet) in cell A1 in $10 jumps in the range $10 to $150.

The Spin control is useful in limiting the range of values the user can enter in a cell and jumps or increments between values.

---