Thank you, Bob. We both know I could not have answered that. :)
hugs & kisses
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Bob Phillips" wrote in message
...
Dim nTime As Double
Sub myClock()
nTime = Now + TimeSerial(0, 0, 1) ' 1 secs
Worksheets("Sheet1").Range("A1").Value = Time
Application.OnTime nTime, "myClock"
End Sub

Sub StopClock()
Application.OnTime nTime, "myClock",,False
End Sub

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Atreides" <atreides1AThotmailD0Tcom wrote in message
...
Thanks Anne, almost there..

That bit of code sets up a periodically running subroutine... but what to
put in the subroutine? How can I make it so that a specific cell always
shows
the instantaneous current time?

Peter

"Anne Troy" wrote:

Probably something like this: http://www.cpearson.com/excel/ontime.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Atreides" <atreides1AThotmailD0Tcom wrote in message
...
Usually the NOW function does not update until you save or re-open
the
file
or press calculate (F9).

However I somehow managed to get it to update constantly (so I could
have
a
countdown clock running). Does anyone know how to do this?

Thanks
Atreides