|
Private Const MDTE_SPECIALDATE As Date = #10/1/2019#
Private Const MDTE_SPECIALTIME As Date = #12:00:00 AM#
Sub StartTimer()
Call TimeOn
End Sub
Sub TimeOn()
Dim intNum As Integer
Dim dteNowTime As Date, dteTime As Date
dteNowTime = Now()
If dteNowTime >= MDTE_SPECIALDATE + MDTE_SPECIALTIME Then
ActiveSheet.Range("B10:B11").Value = 0
MsgBox "时间到!", vbExclamation
Exit Sub
End If
If TimeValue(dteNowTime) > MDTE_SPECIALTIME Then intNum = 1’这行代码运行时显示“类型不匹配”
With ActiveSheet
.Range("B10").Value = MDTE_SPECIALDATE - Date - intNum
dteTime = MDTE_SPECIALTIME - TimeValue(dteNowTime) + _
intNum * 86400
.Range("B11").Value = Hour(dteTime)
.Range("B12").Value = Minute(dteTime)
.Range("B13").Value = Second(dteTime)
End With
mdteTime = dteNowTime + TimeValue("0:0:1")
Application.OnTime mdteTime, "TimeOn"
End Sub
Sub StopTimer()
On Error Resume Next
Application.OnTime mdteTime, "TimeOn", , False
End Sub
|
|