You may want to take a look at Chip Pearson's notes on .ontime:
http://www.cpearson.com/excel/OnTime.aspx

Steve wrote:

On 28 Jan, 12:54, Steve wrote:
Hi all,

HYCH.

Am looking for some code to creat a countdown timer, was hoping for
hh:mm:ss & if possible lower, not sure if it is possible, but any help
would be greatly appreciated.

Steve

Forget this, got the timer sorted,, found old post on this site.

:)

But!

anyway to get a page to refresh after 20 secs?

Steve

--

Dave Peterson