Worksheet_Change Not Detecting DDE Updates

[Trip]

Hello yet again...

I'm full of questions today. Thanks to all for the help!

At any rate I have a ...
Private Sub Worksheet_Change(ByVal Target As Range) routine which works
properly when someone interacts with the sheet yet is unable to detect
when an embedded DDE data feed updates.

Is there another event I can use to capture these changes? Otherwise I
have to run an indefinite loop which checks the cell for updates every
second (or less). I would prefer not to do this if possible because I
do occasionally miss updates.

Any thought would be appreciated.

Thanks!

Trip

 

[Chip Pearson]

I believe you can use the OnData property of the Application
object to name a macro that is to be executed when a DDE data
link is updated. E.g.,

Application.OnData "MyMacro"

Sub MyMacro()
' do your thing
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com