is there a way to put a slider bar into excel

[Lost in yonkers]

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).

 

[Steve]

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

 

[NickHK]

You mean the Scroll Bar control from the controls Toolbar ?

NickHK

 

[Sonny Arcilla]

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