Hello,
I'm trying to create a timer in excel that starts when a cell in range A2:A8 = "Start Timer".
I've managed to get it to work using this code here, although, I'd like it to only work in the range A2:A8.
Also, is it possible to have the time difference update automatically every minute.
Attached, is a copy of the spreadsheet I'm working on.Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then Target.Offset(0, 2) = Now End Sub
Any help would be appreciated.
Timer.xlsm
Bookmarks