DDE - which cell triggered a changed value?

[jonmac]

Hi
I'm trying to get some vba means to detect which cell is triggered when a
DDE changes that cell's value.

Have looked at Worksheet_Calculate but this event seems to be generic for
the whole sheet - and does not return any 'Target.' value (?).

Have also found '.LinkedSources(xlOLELinks)', but cannot see how to use
this to correlate a link to its cell.

Can you make any suggestions, please?

[DonkeyOte]

I'm no DDE expert I'm afraid but the approaches you might adopt will invariably be affected by how many and indeed how frequently your DDEs are updating.