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...
.
|