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?

How to trigger a macro at regular intervals?
 

You can give this a try. Place this in a standard code module...

Sub RefreshStuff()
MsgBox "Tada"
Application.OnTime Now + TimeValue("00:00:05"), "ReCalculate"

End Sub

sub ReCalculate()
application.calculate 'or calculatefull
end sub

--
HTH...

Jim Thomlinson


"ÉH" wrote:

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?

How to trigger a macro at regular intervals?
 

Look at

Application.OnTime

tim

--
Tim Williams
Palo Alto, CA


"ÉH" wrote in message
...
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?

How to trigger a macro at regular intervals?
 

Chip Pearson has lots of instructions at:
http://www.cpearson.com/excel/ontime.htm

ÉH wrote:

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?

--

Dave Peterson