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