Excel 2007 : Scroll Bar Formula

Well you won't get the numerical display with a scroll bar, but you can set a cell link to indicate the current value of the scroll bar.

Create a scroll bar from the Forms Controls.
In the Format Control dialog:
Maximum value = 200
Minimum value = 0
Incremental = 1

Set cell link, say A1 of the sheet.
In B1: =A1-100

Hide cell A1 if desired, and reference cell B1 as needed for positive/negative values.

The only way to set the value to zero after a selection is:

1. Manually set cell A1 to a value of 100 (because this value is centered between 0-200.
2. Use VBA to set the cell value.

However, I would not reset the scrollbar after making a selection but would use a reset button. If you reset it after a change then it will never indicate a selected value.

Code for the command button:

Please Login or Register  to view this content.