display countdown timer in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bert - 12 Jan 2008 01:10 GMT

I'd like to display (in Excel 2003) a countdown timer in a worksheet (either
in a cell or a textbox or other control). I want the user to be able to see
the clock tick down from say 20 seconds to 0 in one second increments (or
decrements, I guess). Is there a function that will do this? If this is
somethingVBA can handle better, I can post this question in the programming
newsgroup.
Thanks,
Bert

Reply to this Message

Gord Dibben - 12 Jan 2008 01:25 GMT

It has to be done through VBA.

You could write code or have someone do it for you.

That someone would be Bob Phillips who has a free downlaodable workbook with a
Timer setup.

http://www.xldynamic.com/source/xld.XtraTime.html

Gord Dibben MS Excel MVP

>I'd like to display (in Excel 2003) a countdown timer in a worksheet (either
>in a cell or a textbox or other control). I want the user to be able to see
[quoted text clipped - 4 lines]
>Thanks,
>Bert

Reply to this Message

Bert - 12 Jan 2008 02:47 GMT

Thanks, Gord...Sounds perfect!

> It has to be done through VBA.
>
[quoted text clipped - 19 lines]
>>Thanks,
>>Bert

Reply to this Message