Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I am playing around with this code to see if it's going to provide what I'm looking to do.
I have my cell that the time displays in formatted as "h:mm AM/PM" (cell formatted) This appears to work, but other than actually displaying the seconds value, I'd like to have some indication of the "pulse" of the clock.
Basically, I'm looking for a way of replacing the seconds value with single character, maybe an "o", that blinks as the seconds count. It doesn't necessary have to be part of the time display format, it can be in a separate cell. Just some means to see if the clock is ticking.
Possible?
I have my cell that the time displays in formatted as "h:mm AM/PM" (cell formatted) This appears to work, but other than actually displaying the seconds value, I'd like to have some indication of the "pulse" of the clock.
Basically, I'm looking for a way of replacing the seconds value with single character, maybe an "o", that blinks as the seconds count. It doesn't necessary have to be part of the time display format, it can be in a separate cell. Just some means to see if the clock is ticking.
Possible?
VBA Code:
Public Sub UpdateTimer()
With wsfront
.Cells(2, 6).Value = Format$(Now, "mm/dd/yyyy")
.Cells(2, 2).Value = Format$(Now, "hh:mm:ss")
End With
Application.OnTime Now + TimeSerial(0, 0, 1), "UpdateTimer"
End Sub