Hi Everyone,
I am trying to make a count up timer that shows milliseconds and then stops at a certain time (e.g: 00:00.00 to 00:05.55). I am only interested in counting minutes, seconds, and milliseconds.
I formatted a custom cell since the time format does not allow for milliseconds.
I tried editing the code used to a make countdown timer I found on this website to make the count up timer.
Sub timer()
interval = Now + TimeValue("00:00.01")
Range("A1") = Range("A1") + TimeValue("00:00.01")
Application.OnTime interval, "timer"
End Sub
I cannot seem to make timer show milliseconds. I also can't figure out how to add a stop time (e.g. 00:05.55). Any help would be much appreciated!
Thank you!