Posted to microsoft.public.excel.programming

Ã‰H

external usenet poster

Posts: 1

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
macro trigger	Leslieac	Excel Discussion (Misc queries)	3	February 2nd 06 09:08 PM
Another way to trigger a macro?	Leon[_5_]	Excel Programming	1	December 22nd 05 06:03 AM
Coverting worksheet macro to regular macro	wammer	Excel Programming	3	July 31st 04 12:03 PM
Macro trigger?	No Name	Excel Programming	3	February 29th 04 05:24 PM
Macro trigger?	excelguru	Excel Programming	0	February 29th 04 06:10 AM

All times are GMT +1. The time now is 09:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us