Thread: TIMER
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default 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