anyone know how to have this vba stay in one sheet? I am in need of help.
![]()
Global clockOn As Boolean Sub runClock() Range("B2").Value = Now() If clockOn = True Then Application.OnTime Now + TimeValue("00:00:01"), "runClock" End If End Sub Sub startClock() clockOn = True runClock End Sub Sub stopClock() clockOn = False End Sub
Bookmarks