Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It seemed pretty simple, drop a spinner on the worksheet, stick some code
into the spinup and spindown to add or subtract 1 to/from the value in a certain cell. Just because the value is a date shouldn't make any difference, after all it's just another number. So why does this retrieve the value of Zero everytime it fires? Yea, I put the current date into the cell F5, then when I click on the spinup the value in F5 becomes Zero! And of course it puts the Zero value +1 back into the cell. What the heck is heck is going on?! :/) Private Sub SpinButton1_SpinDown() Range("F5").Value = DateValue(Range("F5").Value) - 1 End Sub Private Sub SpinButton1_SpinUp() Range("F5").Value = DateValue(Range("F5").Value) + 1 End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How the heck? | Excel Worksheet Functions | |||
Hide and unhide...what the heck!!?? | Excel Discussion (Misc queries) | |||
What the heck is wrong here? | Excel Programming | |||
Spinner box in Excel to adjust date | Excel Worksheet Functions | |||
Date Control using Spinner | Excel Programming |