Hi, this is not an area of expertise on my part but in an effort to get your post moving...

Fundamentally I think the main question here is: are you trying to capture the change itself, or simply the value in a cell at a given point in time?

if just the latter then you might look at the OnTime method... if the former then it's more complicated...

As I recall ... in terms of capturing a DDE change:

DDE updates will not invoke the Worksheet Change event
DDE updates will invoke the Worksheet Calculate event however, that event could trigger for a multitude of other reasons aside DDE

So, in terms of how best to capture the change...

Some people refer to the SetLinkOnData method, e.g:

https://www.oreilly.com/library/view...663/re358.html

Alternatively, a great poster here from yesteryear, Colin Legg, suggested assigning an ActiveX TextBox to the cell being updated, and using the Change Event on the TextBox.