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

'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

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

In article <jay.26xq6o_1146161406.9204@excelforum-nospam.com>, jay.26xq6o_
1146161406.9204@excelforum-nospam.com says...
>
> '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
>
>
> --
> jay
> ------------------------------------------------------------------------
> jay's Profile: http://www.excelforum.com/member.php...fo&userid=2377
> View this thread: http://www.excelforum.com/showthread...hreadid=536927
>
>