OS: XP Professional, Excel 2000.
The Excel Worksheet Change event does not generate a trigger when the value of a cell or a range of cells in the worksheet is changed by an external link. The example I am using is from John Walkenbach's Excel 2000 Power Programming with VBA, Chapter 18, Monitoring a specific range for changes; the code is as follows: [wce]*[/wce]
where InputRange is the range of cells monitored for changes. Each cell in the InputRange defines a DDE link to another application which pushes the data by using the DDE link syntax =application|topic!item.
The above-mentioned book states that the Worksheet Change event is triggered when the cells on a worksheet are changed by the user or an external link. In my case, when I type a new value in a cell of the InputRange, the change event is triggered and the message box pops up. However, when another application changes the value in such a cell via a DDE link declared using the above syntax, the event is not triggered.
I appreciate any solution or suggestion for solving the problem of triggering an event when the value of a cell in an Excel worksheet range is changed by an external application via a DDE link.