Getting spinner to add number to cell

  • Thread starter Thread starter jimbob
  • Start date Start date
J

jimbob

Hello,
I am new to excel and would like to know how to write a
macro that would increase/decrease the value in a cell by pressing their
respective arrows on a spinner. Any help would be greatly appreciated. TIA!
 
jimbob

Don't need a macro.

Right-click on Toolbar. Select "Forms" toolbar.

Click on the Spinner symbol to get a + drawing cursor.

Draw a box for the Spinner with mouse.

Right-click on drawn Spinner and select "Format Control".

Enter or point to a cell that will be incremented.

Set upper and lower limits and increment size.

NOTE: upper limit is 30,000 max.

You now have a Spinner control for the cell you picked.

Hit Spinner up and down arrows to see changes.

Gord Dibben Excel MVP
 
Thanks Gord. I have one other question. Is it possiable to have the
spinner adjust more than one cell at a time?
 
You can't link it to multiple cells, but you could use some helper cells and
formulas that refer back to that linked cell.
 
jimbob

As Dave points out, you can't use a spinner on more than one cell.

You could have the other cells reference the Control cell like =A1 or similar.

A piece of crude code could be used. Assign it to the Spinner.

Sub Spinner1_Change()
Din cel as Range
For Each cel In Range("A2,A9,B4,D1")
cel.Value = Range("A1").Value
Next cel
End Sub

Gord
 
Back
Top