Hi Im trying to get my VBA code to trigger with a boolean that is monitord through Kepserver EX(OPC Server).
in my excel worksheet cell I use the adress " =kepdde|_ddedata!'my_device.My_test_tag'". In my cell I can see the boolean changing value betweene 1/0 when i change
it at the source (a Beijer electonic HMI screen)
and i can trigger my code by manualy typing a change in the cell and if i do a MsgBox for that cell it will also show 1/0 in the msgbox
but will not trigger the Worksheet_Change sub.

am I missing something here?

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = True
If Target.Address = "$A$4" Then
MsgBox Range("A4")
End If
End Sub