Hi.

I'm trying to trigger an event by using DDE to change a specific cell
in EXCEL.

First, i tested my own code (manually, without DDE) by changing that
cell's (cell B1) value and it worked. The code is as below:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
DoSomething
End If
End Sub

However, i tried to use another application and change the cell B1's
value via DDE, that event can't be triggered.

Can anyone give any suggestions? My intention is whever there's a
change in that cell's value, do something.

Thanks a lot.