'Scroll bar' - to increment btwn MIN and MAX value.

[jay]

'Scroll bar' - to increment btwn MIN and MAX value.

Help,

I don't even know if this is possible;

Issue:
I'm looking to put a "scroll bar" in a cell, which could be used to
increment between a minimum value, and maximum value (values in other
cells). I would like to be able to identify the increment value
(sometimes referred to: step size, or index).

Example: (cells and, value or item)

A1 = 100,000 (minimum value)
A2 = 200,000 (maximum value)
A3 = 5,000 (the 'increment' value, step-size etc.)
A5 = <the scroll bar>
A7 = the resulting value between min and max, as adjusted via the
'scroll bar'

It might be obvious that I want to use the A7 value, as a chart
element.

Thanks for any help you can provide.

jay

 

[Tushar Mehta]

I used the scroll bar from the Forms toolbar.

Set the min. to 0, the max. to 20 (calculated as (200000-100000)/5000),
incremental change to 1, page change to 1.

Then, in A7 enter the formula =A1+A5*A3

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions