View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dmoney Dmoney is offline
external usenet poster
 
Posts: 42
Default how spinner increases other cells

Button not designed for more than one cell; however, you
can make it do what u want it to by writing code in the
spinup and spindown events for example. This example
will increment or reduce cells A2 and B2

Private Sub SpinButton1_SpinDown()
Range("a2") = Range("a2") - 1

Range("b2") = Range("B2") - 1
End Sub

Private Sub SpinButton1_SpinUp()
Range("a2") = Range("a2") + 1

Range("b2") = Range("B2") + 1
End Sub

HTH

Devin
-----Original Message-----
My spinner doesn't increase other cells. When spinner is

c1, it only increase
c1 and not c2, when placed at c2...


.