Keeping moving

[wilchong via OfficeKB.com]

In the cell D5 showing the time in the format: 9:23:43 (h:mm:ss), the time
will only update when I click on the cell D5. Therefore, is there any way to
keep "ss" moving without manually click on the cell?

Many thanks for any one advice.
Wilchong

 

[Ben M. Schorr - MVP (OneNote)]

I suppose you could use something like AutoHotKey
(http://www.autohotkey.com) to feed an F9 to Excel every second, but
that seems sort of wasteful. Can you tell us why you need a live clock
in an Excel spreadsheet? There are lots of clock gadgets you can run
that would seem more efficient.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q

 

[Bob Phillips]

Public nTime As Double

Public Sub TimeDisplay()
ActiveSheet.Range("D(").Value = Time
nTime = Now + TimeSerial(0, 0, 1)
Application.OnTime nTime, "TimeDisplay"
End Sub

Public Sub StopTimeDisplay()
Application.OnTime nTime, "TimeDisplay", , False
End Sub

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)