Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMER
I am looking for a code that will constantly check the time from a website or
the computers time ( preferably a website for accuracy) and every half hour, on the 00 & 30, it grabs the time and writes it to a couple cells. So cells A1 will have hour and B1 will have minute. Is their a way this can be done. I don't want to use the =time code, it slows my worksheets down. Any suggestions? thanks, Jase |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMER
Hi Jase
See Chip's page http://www.cpearson.com/excel/OnTime.aspx Note that all code will slow your application down to some degree, and at times clear the Undo memory. HTH. Best wishes Harald "Jase" wrote in message ... I am looking for a code that will constantly check the time from a website or the computers time ( preferably a website for accuracy) and every half hour, on the 00 & 30, it grabs the time and writes it to a couple cells. So cells A1 will have hour and B1 will have minute. Is their a way this can be done. I don't want to use the =time code, it slows my worksheets down. Any suggestions? thanks, Jase |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
timer | Excel Discussion (Misc queries) | |||
Timer in VBA | Excel Discussion (Misc queries) | |||
Timer | Excel Discussion (Misc queries) | |||
Timer | Excel Worksheet Functions | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) |