Countdown Timer In Ms Excel
We are a group of young tutors from Kolkata, India. Digital Library is designed to help students and learners learn and guide about basic tutorials with explanation. We also welcome tutors who want to provide value to our viewers and therefore can teach through our channel.
We are working on :
Ms Excel
English Grammar
More subjects will be added further.
So if you are someone who would want to learn more about these topics consider Subscribing this channel to know more and help students to score more without pursuing a tutor.
Here is a simple method that u can use to create a Countdown Timer In Ms Excel
Click on the image below to watch the full process.
The coding needed :
---------------------------------------------------------------------------------
Sub timer()
interval = Now + TimeValue("00:00:01")
If Range("B2").Value = 0 Then Exit Sub
Range("B2") = Range("B2") - TimeValue("00:00:01")
Application.OnTime interval, "timer"
End Sub
Sub stop_timer()
Application.OnTime EarliestTime:=interval, Procedure:="timer", Schedule:=False
End Sub
Sub reset_timer()
Range("B2").Value = "00:05:00"
End Sub
---------------------------------------------------------------------------------
Thank you
By Digital Library
2 Comments
Very helpful for me, Thanks a lot.
ReplyDeletegetting Run time error '1004' : Method 'OnTime" of object'_Application failed
ReplyDeleteStop timer is not working , error at the below line
Application.OnTime EarliestTime:=interval, Procedure:="timer", Schedule:=False