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.

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

On Wed, 4 Apr 2007 14:44:00 -0700, James O
wrote:

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.

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" wrote:

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

On Wed, 4 Apr 2007 14:44:00 -0700, James O
wrote:

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.

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/so...ital_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

On Thu, 5 Apr 2007 14:38:00 -0700, James O
wrote:

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" wrote:

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

On Wed, 4 Apr 2007 14:44:00 -0700, James O
wrote:

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.