Loop

Hi all,

I wonder how I can update a cell every 60 seconds or so.
Is there a specific function to set the specific period?

Thanks,

Gus

[This followup was posted to microsoft.public.excel.worksheet.functions
with an email copy to Gus.
Please use the newsgroup for further discussion.]

XL updates open workbooks only when it believes something has changed.
To force an update every x seconds, use a programmatic solution. Look
up OnTime in XL VBA help or search the google.com archives of the XL
NGs for that keyword.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi all,

I wonder how I can update a cell every 60 seconds or so.
Is there a specific function to set the specific period?

Thanks,

Gus