View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trip[_3_] Trip[_3_] is offline
external usenet poster
 
Posts: 44
Default Worksheet_Change Not Detecting DDE Updates

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