When countdown hits zero

[James O]

I was wondering if there was a way for say, an anamated explosion in stars,
will happen when countdown hits zero. Also, is there a way to have the
countdown coutdown seconds, minutes, hours, days, and if so have them
coutdown while watching it, so you can see it when the spreadsheet it is in
is open. I am using excel 2002.

 

[Gord Dibben]

James

Only by using VBA code, which would mean you could do nothing else while it was
running.

Maybe re-think your project needs.


Gord Dibben MS Excel MVP

 

[James O]

VBA code would be fine. I understand it would be the only thing running. I
am not that good at writing codes though, trying to learn.

 

[Gord Dibben]

James

Here is some clock stuff, you may find something to help.

http://www.andypope.info/fun/clocks.htm


http://xcelfiles.homestead.com/VBA_Clock.html


http://www.tushar-mehta.com/excel/software/clocks/digital_clock.htm


http://j-walk.com/ss/excel/files/clockchart.htm


http://kenmzoka.com/20001010CountdownClock.xls


Chip Pearson designed an analog clock that ticks every second at:
http://www.cpearson.com/excel/download.htm


Gord