Loop

G

Gus

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
 
T

Tushar Mehta

[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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update several ppt documents from a single excel file 0
Macro to select and delete levels of a document 2
Integrating information from Word to Excel (not mail merge) 1
Macro loop until end of file 2
How can the font and size of (all) citation numbers be altered? 1
Amending meeting cancels all future meetings 0
Loop through pages and insert header image 0
Need VBA Macro to Loop through pages and print counter in footer of each page 9

Top