I have solved my problem by Worksheet_Calculate(). This solution will
work as long as i dont have another formula in my excel which my excel
has none of it.

I will try SetLinkOnData when i have spare times.

Anyway, can anyone give any clue for me to try apart from DDE? I heard
of some other way of doing communication between different
application, like OLE automation and etc. Can anyone give some clues
for me to start from there?

Thanks.



On Jul 7, 8:45*pm, Tom Ogilvy
wrote:
I would expect the change event to fire on a DDE update in xl2000 and later

However, you can also use the Old method of the SetLinkOnData method. *See
VBA help for details.

--
Regards,
Tom Ogilvy

"albertleng" wrote:
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.