count up timer help with milliseconds

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!