I have read a number of posts online relating to the making of a stopwatch in VBA. I have been able to make the foundation of what i am looking for and i am now trying to tidy it up.
I am looking for suggestions of how i can make a cell show a running clock (the elapsed time). The stopwatch will be used to time cyclists on a velodrome so they may do 40 or 50 laps (and there will be 4 or 5 riders at once on the track). I will make a button for each rider which populates a specific column with split times.
Here is my code for the macro that adds a split time to the list.
ActiveCell.Value = Format(Time, "hh:mm:ss:" & Right(Format(Timer, "#0.00"), 2))