spinner to change more than one cell at a time

  • Thread starter Thread starter deanimate
  • Start date Start date
D

deanimate

Guys if you could me with this then thankyou loads as its killing me at
the mo!

I have ten cells with some values in and have put a spinner onto the
sheet.
All i want is for the spinner to adjust (add or takeaway) the values in
each of the ten cells at the same time

I can get the spinner to do one cell no problem but not all ten cells
at once :-/

Any ideas?!
 
Use the SpinUp and SpinDown events. In the code module for the worksheet
which contains the spinner control, use code like the following:

Private Sub SpinButton1_SpinDown()
Range("A1").Value = Range("A1").Value - 1
Range("B1").Value = Range("B1").Value - 1
Range("C1").Value = Range("C1").Value - 1
End Sub

Private Sub SpinButton1_SpinUp()
Range("A1").Value = Range("A1").Value + 1
Range("B1").Value = Range("B1").Value + 1
Range("C1").Value = Range("C1").Value + 1
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
So have the spinner link to a single reference cell, and then tie all other ten
cells to that reference cell with appropriate formulas to do what you need.
 
Back
Top