Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Movable "slider" to adjust a range with the mouse?
Does Excel have any kind of dynamic slider? For instance, something that
would allow you to modify a percentage markup between 15% and 25% by sliding a "bar" horizontally within a cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Movable "slider" to adjust a range with the mouse?
Right click on any visible Toolbar and select the CONTROL TOOLBOX.
When the toolbox is displayed, click the SCROLL BAR tool and draw the scroll bar across the row you want it to appear on. (Holding down the Alt key while drawing the tool forces the scroll bar to take on the height of the row you're drawing in). Right click on the scroll bar and select properties. The scroll bar can only work with whole number, not percentages so the following will provide a work around for this limitation: For instance, let's say that the percentage value needs to be in cell A1. To do that we will need to place the value the scroll bar returns in one cell and use a formula in cell A1 to divide that value by 100 to get your percentage. In the properties list, locate the LINKED CELL property and select K1 as the target cell for the return value. Locate the LARGE CHANGE property and set the value to 1 and then locate the SMALL CHANGE property and set its value to 1. Locate the MIN property and set that to 15, and then locate the MAX property and set that to 25. Close the properties window and then click the first button on the CONTROL TOOLBOX (the DESIGN button) to toggle design mode off. In cell A1 enter the following formula: =K1/100 You can now slide the toolbar button to increase/decrease your percentage. Personally, i would use the spinner button, which will do the same as the scroll bar but it will take up less room on your worksheet. Just substitute the spinner for the scroll bar and follow the same instructions. Hope this helps. -- Kevin Backmann "rwhtx" wrote: Does Excel have any kind of dynamic slider? For instance, something that would allow you to modify a percentage markup between 15% and 25% by sliding a "bar" horizontally within a cell. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Movable "slider" to adjust a range with the mouse?
From the Forms commandbar, drag a scroll bar to your sheet, then use the properties to set the link
cell. Size it how you want, but you will need to divide the value in the link cell by 100 to get a percentage, since the scroll bar must return an integer value. HTH, Bernie MS Excel MVP "rwhtx" wrote in message ... Does Excel have any kind of dynamic slider? For instance, something that would allow you to modify a percentage markup between 15% and 25% by sliding a "bar" horizontally within a cell. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Movable "slider" to adjust a range with the mouse?
Yes, this is for Excel 2003.
Go to View/Toolbars and select Control Toolbox; from the toolbox, select the 'scroll bar' and drag to your worksheet. With the scroll bar selected, select 'properties' from the toolbox and update the Max and Min numbers. Select a linked cell - this is where the value of the scroll bar will be entered. To get a percent, another cell must be used to divide the linked cell by 100 "rwhtx" wrote: Does Excel have any kind of dynamic slider? For instance, something that would allow you to modify a percentage markup between 15% and 25% by sliding a "bar" horizontally within a cell. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Movable "slider" to adjust a range with the mouse?
In Excel 2003, I am able to create a fully functional scroll bar when I use
the "Forms" toolbox. However, when I create a scroll bar from the "Control Toolbox" toolbar, I can get an image of the scroll bar, but there is no funtionality. I left click my mouse over the image and it immediately changes to edit mode, including changing the pointer to a sizing icon (four small arrows). Is there a reason why I cannot make a operating scroll bar from the "Control Toolbox" toolbar? "Kevin B" wrote: Right click on any visible Toolbar and select the CONTROL TOOLBOX. When the toolbox is displayed, click the SCROLL BAR tool and draw the scroll bar across the row you want it to appear on. (Holding down the Alt key while drawing the tool forces the scroll bar to take on the height of the row you're drawing in). Right click on the scroll bar and select properties. The scroll bar can only work with whole number, not percentages so the following will provide a work around for this limitation: For instance, let's say that the percentage value needs to be in cell A1. To do that we will need to place the value the scroll bar returns in one cell and use a formula in cell A1 to divide that value by 100 to get your percentage. In the properties list, locate the LINKED CELL property and select K1 as the target cell for the return value. Locate the LARGE CHANGE property and set the value to 1 and then locate the SMALL CHANGE property and set its value to 1. Locate the MIN property and set that to 15, and then locate the MAX property and set that to 25. Close the properties window and then click the first button on the CONTROL TOOLBOX (the DESIGN button) to toggle design mode off. In cell A1 enter the following formula: =K1/100 You can now slide the toolbar button to increase/decrease your percentage. Personally, i would use the spinner button, which will do the same as the scroll bar but it will take up less room on your worksheet. Just substitute the spinner for the scroll bar and follow the same instructions. Hope this helps. -- Kevin Backmann "rwhtx" wrote: Does Excel have any kind of dynamic slider? For instance, something that would allow you to modify a percentage markup between 15% and 25% by sliding a "bar" horizontally within a cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"Adjust row height" not working properly | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |