+ Reply to Thread
Results 1 to 2 of 2

Worksheet_Change Not Detecting DDE Updates

  1. #1
    Trip
    Guest

    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


  2. #2
    Chip Pearson
    Guest

    Re: Worksheet_Change Not Detecting DDE Updates

    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




    "Trip" <[email protected]> wrote in message
    news:[email protected]...
    > 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1