TIME CLOCK code?
 

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?

TIME CLOCK code?
 

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)




"Jase" wrote in message
...
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?

TIME CLOCK code?
 

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

"Chip Pearson" wrote:

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)




"Jase" wrote in message
...
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?

TIME CLOCK code?
 

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?

"Chip Pearson" wrote:

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)




"Jase" wrote in message
...
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?

TIME CLOCK code?
 

Ok, now everytime I just run it it closes out on me after 2 seconds.

"Chip Pearson" wrote:

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)




"Jase" wrote in message
...
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?