Because I got a lot of help from here, so I will contribute my knowledge
PHP Code:
'Begin to count
StopTimer = False
SchdTime = Now()
[B22].Value = Format(Etime, "hh:mm:ss")
Application.OnTime SchdTime + OneSec, "Sheet5.NextTick"
'stop to count
StopTimer = True
Beep
'reset the Clock
StopTimer = True
Etime = 0
[B22].Value = "00:00:00"
Bookmarks