|
Sub StartClock()
LastUpdateTime = Now()
Application.OnTime Now + TimeValue("00:00:01"), "UpdateClock"
End Sub
Sub StopClock()
On Error Resume Next
Application.OnTime EarliestTime:=LastUpdateTime, Procedure:="UpdateClock", Schedule:=False
On Error GoTo 0
End Sub
Sub UpdateClock()
LastUpdateTime = Now()
Dim CurrentHour As Integer
Dim CurrentMinute As Integer
Dim CurrentSecond As Integer
CurrentHour = Hour(LastUpdateTime)
CurrentMinute = Minute(LastUpdateTime)
CurrentSecond = Second(LastUpdateTime)
Range("A1").Value = Format(CurrentHour, "00") & ":" & Format(CurrentMinute, "00") & ":" & Format(CurrentSecond, "00")
Application.OnTime Now + TimeValue("00:00:01"), "UpdateClock"
End Sub
|
评分
-
1
查看全部评分
-
|