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