Excel VBA倒计时

Private myTime As Date
Private Const endTime As Date = #11/25/2021 2:00:00 PM#

Sub StartTimer()
    Call TimeOn
End Sub

Sub TimeOn()
    Dim deltaTime As Variant
    Dim days As Long, hours As Long, minutes As Long, seconds As Long
    myTime = Now()
    deltaTime = DateDiff("s", myTime, endTime)
    
    days = Fix(deltaTime / 86400)
    hours = Fix((deltaTime - 86400 * days) / 3600)
    minutes = Fix((deltaTime - days * 86400 - hours * 3600) / 60)
    seconds = deltaTime - days * 86400 - hours * 3600 - minutes * 60
    
    Range("A2") = days
    Range("B2") = hours
    Range("C2") = minutes
    Range("D2") = seconds
    
    Application.OnTime myTime + TimeValue("0:00:01"), "StartTimer"
    
End Sub
Sub KillTimer()
    On Error Resume Next
    Application.OnTime myTime + TimeValue("0:00:01"), "StartTimer", Schedule:=False
End Sub



  • 0
    点赞
  • 5
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值