TIME CLOCK code?

J

Jase

I am trying to figure out a better more accurate way to run a clock with in
an excel sheet rather then using the NOW() function. I have a macro that runs
off a website but the problem is it is a contantly running code and when i
try to execute other macro's while it runs it disables the clock macro and
debugs on me. Any suggestions?
 
C

Chip Pearson

On way would be to use Application.OnTime to run a macro every second or two
(or more). If Excel is busy when the OnTime pops (e.g., another macro is
running or you are editing a cell), OnTime will defer the event until Excel
is ready. See www.cpearson.com/Excel/OnTime.aspx for more details about
working with OnTime.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
J

Jase

A little confused. where does this display a timer if it does. Am I suppose
to enter my own code with in your code? A little more direction would be
great.

thanks
 
J

Jase

Ok I got the code running and updating a clock within my excel sheet but like
you said it keeps closing out on me when I try to make changes with in my
sheet. I thought the coe is suppose to pause until I am done?
 
Top