Bob,

This sounds like a possible solution to a problem I am
trying to solve. Would you be so kind as to send me this
workbook?

Thanks much,
Walt Boraczek
-----Original Message-----
John,

Probably the right decision <vbg!

Do you want me to send you the workbook, just out of
interest?

Bob


"John" wrote in message
u...
Thank you bob

definitely there is a bit of code behind it
I have taken the easy way out of this
I have put the command "Calculate" at few places in my
code so each time
the
code checks for expected events it also does a calc.
This occurs every few
seconds, the PC is dedicated for data collection anyway.

many thanks

John

"John" wrote in message
u...
if I have the NOW() function say in cell A1
and then function =Text(A1, "hh:mm:ss") in cell B1,
how do I get the
time
display on the screen refreshed every second or so..

any help will be appreciated

John






.