View Single Post
 
Old 11-20-2013, 09:51 PM
dlowrey dlowrey is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 29
dlowrey is on a distinguished road
Default 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
Reply With Quote