![]() |
#1
|
|||
|
|||
![]()
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 |
Tags |
activex control, increment value, spinbutton |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
marynomore | Excel | 2 | 03-27-2013 05:36 AM |