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