Excel VBA - Time loop

A simple video showing how to get a code to repeat itself every second.

Here is the code from the video:

[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

[MohMoh]

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

[michaelhawkins]

Will the counter continue even when excel is closed?

[harshilkaswala]

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

[eenab]

Thanks a lot. Wish you continued this Excel VBA.

[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.

[vksvishwa]

Thanks a lot. Very effective and simple.