Hi Bob,
how should I run the clock procedure to get it started in excel, as you see
the VBA code I have pasted is not working please help me, thanks.

Daoud Fakhry


"Bob Phillips" wrote:

As I said, you have to run the clock procedure to get it started.

--
HTH

Bob

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

"Daoud Fakhry" wrote in message
...
Hi Bob,
I put the code in a module.
B1 doesn't have the X value.
I just put this code in a module and that is it.
I mean that the clock in sheet1 A1 is not working, even it is not showing
up.

Thanks for your help in advance.

"Bob Phillips" wrote:

Is clock in a standard module (it should be)?

Does B1 have the value X (it shouldn't, except to stop the clock)?

Do you fire the procedure initially somehow?

What does not working mean?

--
HTH

Bob

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

"Daoud Fakhry" wrote in message
...
Hi all,
I have used the following VBA code to have the real time clock in one
of
my
cells. but it is not working. can any one help me.

Sub clock()
If ThisWorkbook.Worksheets(1).Range("B1").Value = "X" Then Exit Sub
ThisWorkbook.Worksheets(1).Range("A1").Value = Format(Now, "hh:mm:ss
AM/PM")
Application.OnTime Now + TimeSerial(0, 0, 1), "clock"
End Sub