Thread: Spinbutton
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Spinbutton

Try this.

Create SpinButton1 from the Control Toobox and set the Linked Cell
property to A1
and it's code as follows:

Private Sub SpinButton1_Change()
Range("A2") = 100 - Range("A1")
End Sub

Create SpinButton2 from the Control Toobox and set the Linked Cell
property to A2
and it's code as follows:

Private Sub SpinButton2_Change()
Range("A1") = 100 - Range("A2")
End Sub