![]() |
|
|
|
#11
|
|||
|
|||
|
.
This version should answer all your questions : Code:
Option Explicit
Sub starttimer()
On Error Resume Next
Application.OnTime Now + TimeValue("00:00:01"), "nexttick"
End Sub
Sub nexttick()
On Error Resume Next
If Sheet1.Range("S9") = 0 Then
Sheet1.Range("S9").Value = "0:0:10"
Exit Sub
End If
Sheet1.Range("S9").Value = Sheet1.Range("S9").Value - TimeValue("00:00:01")
starttimer
End Sub
Sub resettimer()
Sheet1.Range("S9").Value = "0:0:10"
End Sub
Sub stoptimer()
On Error Resume Next
Application.OnTime Now + TimeValue("00:00:01"), "nexttick", , False
End Sub
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| #REF Error when calling VBA Function | RodneyJ | Excel Programming | 1 | 01-21-2016 12:42 PM |
| Re-Calling Sent Email | freschij | Outlook | 1 | 12-06-2010 09:16 PM |
| calling images with a button | sammer021486 | PowerPoint | 0 | 01-13-2010 08:24 AM |
first timer
|
papamadre | Forum Support | 1 | 10-24-2009 06:26 AM |
| Bingo Cards | office_mike | Excel | 1 | 11-29-2008 10:17 PM |