Scroll slider

[daya007]

Hi
I have a requirement where user wants a scroll bar in Excel which will be pointed to center at first which makes a cell value zero. When user slides the scroll bar to right the cell values must increase 10 %. When slider is at right end it should point 100% as cell value. Viceversa when user moves the slider to left. Cell should display negative values. Values must be multiples of 10. I dono VBA. Please help me with this requirement.

Thanks
Daya

[Bob Phillips]

Add you srollbar with the following properties

- minimum value 0
- maximum value 200
- change value 10

Set the linked cell to some cell off screen, say IV2, and set that value to 100. Then set another cell, say M2, with the formula

=(IV2-100)/100

and format that cell as a percentage

Then set