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