Continuous Refresh

H

Huber57

I would like to continuously refresh a spreadsheet (as if I was holding down
the F9 key). Can anyone help?

Doug
 
R

raypayette

Usually clicking Tools, Options, Calculations, Automatic recalculates
whe workbook every time a change is made. Do you need something else?
 
H

Huber57

Ray,

I would like it to refresh constantly. I am trying to build a "countdown
clock" so that is shows me the date and time of an event and then the days,
hours, minutes and seconds until that event happens.

For example:

A1: August 15, 2006 9:00 AM
A2: =(A1-NOW())*24 ---- this would show me hours remaining
A3: =A2*60 --------- this would show me minutes remaining
etc, etc.

When it refreshes constantly, it will show me a countdown.

Doug
 
D

Desert Piranha

raypayette said:
Usually clicking Tools, Options, Calculations, Automatic recalculates
whe workbook every time a change is made. Do you need something else?Hi raypayette,
Click to expand...

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
 
H

Huber57

Ray and Desert Piranha,

Thanks for the links. But, those clock tools don't help me with refreshing
the page. Is there a short piece of VBA code I can write to constantly
refresh the calcs?

Doug
 
D

Desert Piranha

Huber57 said:
Ray and Desert Piranha,

Thanks for the links. But, those clock tools don't help me with
refreshing
the page. Is there a short piece of VBA code I can write to
constantly
refresh the calcs?

DougHi Huber57,
Click to expand...

Maybe you could use something like this in a loop.

Application.Calculate
or
ActiveSheet.Calculate
 
H

Huber57

Mr. Piranha,

Can you help me with a continuous loop VBA script? I don't know how any of
that stuff works.

Doug
 
R

raypayette

If you don't know how a continuous loop works, you should study this an
obtain general programming knowledge before asking help from this forum
 
Top