Triggering a macro using a DDE linked value

Posted by AMC on February 19, 2001 6:28 PM

I need to Trigger a macro by monitoring a Value in a Cell that is updated by a DDE hot link. When the value changes from 0 to 1 I need to automatically trigger another macro.

Thanks,

AMC

Posted by Dave Hawley on February 19, 2001 8:25 PM

Hi AMC

Right click on the Sheet name tab and select "View Code" then place this in and modify to Suit;

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Address = "$A$1" Then
'My Macro
End If
End Sub

OzGrid Business Applications