Counter count down

[Legacy 420921]

how i create counter that count down to 9/5/19. I not sure how do that? i want day hours minutes and sec



Thanks you

Thomas

 

[Logit]

Re: i need help with counter count down

.
Paste in a regular module :

Option Explicit


Public bTimerOn As Boolean


Sub ToggleTimer() ' This Sub will switch the automatic timer on if it was off before, and vice-versa
bTimerOn = Not bTimerOn


Refresh ' It calls the Refresh Sub
End Sub


Sub Refresh() ' This Sub calculates the sheet and tells Excel to call it again after 1 second
Application.Calculate


If bTimerOn Then ' If bTimerOn is True, start refreshing automatically
Application.OnTime Now + TimeValue("00:00:01"), "Refresh" ' The intervall is set to 1 second but can be changed variably
End If
End Sub

Download : https://www.amazon.com/clouddrive/share/hQijQVAHPCivl6aIW23F0E5c2c91dtIm9mco4L3QgFT

 

[Legacy 420921]

Re: i need help with counter count down

that I wanted, but I do not want have a button to press. I want it start when I open file automatically counts down


Thanks You

Thomas

 

[Logit]

Re: i need help with counter count down

.
https://www.ozgrid.com/VBA/auto-run-macros.htm