Scroll Bar or Spinner 0 to 100 by Hundredths

  • Thread starter Thread starter paul_cross
  • Start date Start date
P

paul_cross

I'm trying to get a spinner control or scroll bar to increase the
values of a cell from 0 to 100 by hundredths and I'm stuck. I've been
trying using 2 cells and some creative formulas but haven't found the
right combination. Anyone have a solution jump to mind?

-- Paul Cross
 
I put a scrollbar from the Forms Toolbar on a worksheet.

I rightclicked on it and chose Format Control
On the Control Tab, I set the minimum value to 0 and the maximum to 10000.
And assigned A1 to be the linked cell.

Then I put this formula in B1:
=a1/100

It seemed to work ok.
 
Back
Top