Not sure if this can be done but I need 70 timers on a worksheet. When data is added to a cell, the timer would start. When I highlight this cell or the station number for this cell I would like a message box to open stating the elapsed time and when the cell contents are deleted the timer would reset to 00:00. An alternative to the above would be to have the station numbers in a column on the side with the elapsed time next to it which would always be visible and if the cell is empty the timer would be 00:00. Most of the time at least 60 stations would be active. Is there a limit to the number of active timers running at one time or will this cause havoc with the worksheet? I have attached a simplified worksheet.
Appreciate any help or any suggestions how to do it better.
Bookmarks