Hi Guys!
I'm working on making a dashboard, which requires a timer in the sheet. But I want this timer restricted to one sheet only. When I copy the contents to another sheet, I want the timer to stop in that sheet, but its still going on. Please help!
Currently I'm using this code.
Public Sub UpdateTimer()
Sheets("Dashboard").Cells(2, 11).Value = Format$(Now, "mm/dd/yyyy")
Sheets("Dashboard").Cells(3, 11).Value = Format$(Now, "hh:nn:ss")
Application.OnTime Now + TimeSerial(0, 0, 1), "UpdateTimer"
End Sub
I'm working on making a dashboard, which requires a timer in the sheet. But I want this timer restricted to one sheet only. When I copy the contents to another sheet, I want the timer to stop in that sheet, but its still going on. Please help!
Currently I'm using this code.
Public Sub UpdateTimer()
Sheets("Dashboard").Cells(2, 11).Value = Format$(Now, "mm/dd/yyyy")
Sheets("Dashboard").Cells(3, 11).Value = Format$(Now, "hh:nn:ss")
Application.OnTime Now + TimeSerial(0, 0, 1), "UpdateTimer"
End Sub