Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slider bars in Excel | Charts and Charting in Excel | |||
How do I set up slider bars to input data in Excel? | Excel Worksheet Functions | |||
how to use a knob or level slider in microsoft excel | Excel Programming | |||
How do I set up radio buttons and slider bars in excel? | New Users to Excel | |||
Excel VBA - is there a multiple slider sliderbar control | Excel Programming |