I would like to continuously refresh a spreadsheet (as if I was holding down
the F9 key). Can anyone help?
Doug
I would like to continuously refresh a spreadsheet (as if I was holding down
the F9 key). Can anyone help?
Doug
Usually clicking Tools, Options, Calculations, Automatic recalculates whe workbook every time a change is made. Do you need something else?
Best regards,
Ray
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
"raypayette" wrote:
>
> Usually clicking Tools, Options, Calculations, Automatic recalculates
> whe workbook every time a change is made. Do you need something else?
>
>
> --
> raypayette
>
>
> ------------------------------------------------------------------------
> raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
> View this thread: http://www.excelforum.com/showthread...hreadid=566221
>
>
C Pearson designed an analog clock that ticks every second at:
http://www.cpearson.com/excel/download.htm
Hi raypayette,Originally Posted by raypayette
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
Thx
Dave
"The game is afoot Watson"
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
"Desert Piranha" wrote:
>
> raypayette Wrote:
> > Usually clicking Tools, Options, Calculations, Automatic recalculates
> > whe workbook every time a change is made. Do you need something else?Hi raypayette,
>
> 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
>
>
> --
> Desert Piranha
>
>
> ------------------------------------------------------------------------
> Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
> View this thread: http://www.excelforum.com/showthread...hreadid=566221
>
>
Hi Huber57,Originally Posted by Huber57
Maybe you could use something like this in a loop.
Application.Calculate
or
ActiveSheet.Calculate
Perhaps this reference to volatile UDF's is what you need?
http://blogs.officezealot.com/whitec...1/29/4005.aspx
Mr. Piranha,
Can you help me with a continuous loop VBA script? I don't know how any of
that stuff works.
Doug
"Desert Piranha" wrote:
>
> Huber57 Wrote:
> > 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,
>
> Maybe you could use something like this in a loop.
>
> Application.Calculate
> or
> ActiveSheet.Calculate
>
>
> --
> Desert Piranha
>
>
> ------------------------------------------------------------------------
> Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
> View this thread: http://www.excelforum.com/showthread...hreadid=566221
>
>
If you don't know how a continuous loop works, you should study this and obtain general programming knowledge before asking help from this forum!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks