is there a way to put a slider bar into excel
 

I want to put a slider bar into excel so that i can allocate differnt values
to two different numbers (kind of like something you see in a financial
analyzer program).

is there a way to put a slider bar into excel
 

I would like the same function have you received an answer?

"Lost in yonkers" wrote:

I want to put a slider bar into excel so that i can allocate differnt values
to two different numbers (kind of like something you see in a financial
analyzer program).

is there a way to put a slider bar into excel
 

You mean the Scroll Bar control from the controls Toolbar ?

NickHK

"Steve" wrote in message
...
I would like the same function have you received an answer?

"Lost in yonkers" wrote:

I want to put a slider bar into excel so that i can allocate differnt
values
to two different numbers (kind of like something you see in a financial
analyzer program).

Slider Bar
 

Add "Microsoft Windows Common Controls 6.0 (SP6)" as a reference in the Visual Basic Editor. From there put your spreadsheet into Edit mode and view the "Control Toolbox" toolbar. On that toolbar choose "More Controls" then Microsoft Slider Control 6.0 (SP6). Click somewhere in the spreadsheet and the slider should then be ready to alter. Right click on it click on View Code. Once in the Visual Basic Editor (with the Click event ready to be edited), choose the "Scroll" event from the upper right-hand corner where it initially shows "Click". Program the scroll event to update some data range every time it scrolls to a new value. You can set the min/max of the Slider by right-clicking on it.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com