time/counter format

hi

i am making a stopwatch. i would like milliseconds with it. for my macro, i use this code for the start button

Sub StartTimer()
nr = ThisWorkbook.Sheets("sheet1").Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(nr, 1) = Time

End Sub

i thought if i changed the 'time' to mm:ss:000 it would work, but it doesnt.have i forgot to add something?

thanks

im wanting to make a stopwatch. i have used Time as its the closest thing i can do that counts seconds. however, it's not really time that i want, just the seconds/milliseconds

so there is no simple way just to modify my code?

is better yes thanks. but its still based around time, the first click goes to whatever second the clock is on rather than start at 0

there are 2 buttons on my sheet. this one, and a reset one. macro assigned for each.

first time i press the 'start button' it should start from 0. each time i press the same button it keeps listing each time, so if press the button every second it will fill the A column with running figures.
the next button i have code for is a 'reset button' which wipes all data from the A column so i can start from 0 again and repeat with the start button