Help with incrementing Spinbutton value.
Problem 1: The cell D4 value increases or decreases by 2 when the spinbutton is clicked. The spinbutton is an activex control named "Spindays".
Problem 2: The value will go below 0 (ex. -1), even though the property Min is set to 0.
What did I miss?
Thanks for your help. The code is below.
- DL
Private Sub SpinDays_SpinDown()
With Range("D4")
.Value = Range("D4").Value - 1
End With
End Sub
Private Sub SpinDays_SpinUp()
With Range("D4")
.Value = Range("D4").Value + 1
End With
End Sub
|