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.

Link a cell's formula to the DDE cell. It can be as simple as =$B$1. Then
use the Worksheet_Calculate event. This unfortunately doesn't give you the
calculation of a specific cell the way Worksheet_Change does.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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

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.

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.