Thread: How to trigger a macro at regular intervals?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ÉH ÉH is offline
external usenet poster
  
Posts: 1
Default How to trigger a macro at regular intervals?
I have a workbook that is being updated through DDE links. I also want to
trigger the recalculation of a cell at regular intervals (every 5 seconds,
for example) while the DDE updates are happening. How can I do this? I tried
the Wait function in a macro, but this interrupts all updates. Any other
ideas?
Reply With QuoteReply With Quote