View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default 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.