Excel VBA - Time loop

[@TonVermeij]

Terrific! That is what is was searching for!

[@Gingerbreadaddict]

Hi, great vid. thanks for posting.
I'm trying to make it run faster, e.g. call the "main" sub every 1/2 second rather than every 1 second. I tried dividing the "TimeValue("00:00:01")" by 2, but it doesn't work. Any ideas?
The code I tried was something like this:
Sub timer()
Application.OnTime Now() + TimeValue("00:00:01")/2, "main"
End Sub

[@3eenab]

Thanks a lot. Wish you continued this Excel VBA.

[@harshilkaswala1886]

This is what i was looking for Thank you so much!

[@vksvishwa]

Thanks a lot. Very effective and simple.

[@7mrbonline7]

How can you make it go faster?

[@Moh23Moh]

Very good but it does accept only integer seconds
what if i need fractions

[@BlazeGamingUK4EVER]

great video, very informative!

[@michaelhawkins4169]

Will the counter continue even when excel is closed?

[@bongzsmalawu1614]

Thanks for this

[@SuperHanme]

actually, the timer is still running, when you click the "off". this design model is not correct, because when you click the "On" again, it shows the same times running in the background.

[@EngineerClearly]

I don't know yet :(

[@quintonballenden1436]

I like that. Thank you

[@henrifeuga249]

Excellent. Thank you so much!

[@luisrodrigues3110]

Amazing !!! Thank you very much !!!

[@oferico1]

works well! thanks!