| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
