cubbycub
10-28-2008, 10:29 AM
Hi all,
This is hard to explain but here goes...
The attached file is just a test bed in order for me to test the items I need, to create a time sheet.
I would like to select the interval period using the top spin button and then use this value to increment my start and stop time using the bottom 2 spin buttons. The fly in the proverbial ointment though is that I would like the spin button reference cell to reset once the end of the day has been reached. (see the macro below this is run as soon as the spin button is pressed).
There must be a neater method than this to reset the count. This would require a macro for each spin button.:dunno
Any help would be greatly appreciated.
Sub Macro1()
'
' Macro1 Macro
'
'
If Cells(5, 3).Value > 1 Then Cells(5, 2).Value = 1
End Sub
This is hard to explain but here goes...
The attached file is just a test bed in order for me to test the items I need, to create a time sheet.
I would like to select the interval period using the top spin button and then use this value to increment my start and stop time using the bottom 2 spin buttons. The fly in the proverbial ointment though is that I would like the spin button reference cell to reset once the end of the day has been reached. (see the macro below this is run as soon as the spin button is pressed).
There must be a neater method than this to reset the count. This would require a macro for each spin button.:dunno
Any help would be greatly appreciated.
Sub Macro1()
'
' Macro1 Macro
'
'
If Cells(5, 3).Value > 1 Then Cells(5, 2).Value = 1
End Sub