| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TIME CLOCK CODE | Excel Discussion (Misc queries) | |||
| How do I calculate time in excel (clock in and clock out | Excel Discussion (Misc queries) | |||
| Change EXCEL Clock to Standard Clock or Military Time | Excel Worksheet Functions | |||
| can cell's act like time clock at a certen time/date for payments | Excel Discussion (Misc queries) | |||
| Time Clock | Excel Worksheet Functions | |||
Linear Mode
