How Do I detect a cell update via DDE ?

[sooznaid]

I would like to run my macro whenever a cell is updated by a DDE.

 

[PaddyD]

Hi - welcome to the board!

see if the 'lastchng.zip' file here:

http://www.bmsltd.co.uk/Excel/Default.htm

has what you need. Post back if you want more...

Paddy

 

[Joe Was]

Use a Change Event macro which tests for a:

Private Sub Worksheet_Change(ByVal Target as Range)
If Target.Application.DDEAppReturnCode = True Then
MsgBox "Dynamic Data Exchange"
End If
End Sub