Tweet
hi,
I have coded an efs indicator which also sends via DDE (=esignal|efs!'.....') the indicator value to my excel spreadsheet in realtime and this works fine.
Now I want to start a macro each time I am receiving an DDE Update from esignal.
When using the below VBA code in the sheet where the cell is being updated from the esignal DDE it does not start the macro.
BUT when I am manually changing the cell the macro is being executed as it should do.
Any help on this issue (I know it is more an excel issue) would be much appreciated.
-----------
Excel Macro source code:
Private Sub Worksheet_Change(ByVal target As Range)
If target.Address = "$E$9" Then Call MyMacro
End Sub
---------
I have coded an efs indicator which also sends via DDE (=esignal|efs!'.....') the indicator value to my excel spreadsheet in realtime and this works fine.
Now I want to start a macro each time I am receiving an DDE Update from esignal.
When using the below VBA code in the sheet where the cell is being updated from the esignal DDE it does not start the macro.
BUT when I am manually changing the cell the macro is being executed as it should do.
Any help on this issue (I know it is more an excel issue) would be much appreciated.
-----------
Excel Macro source code:
Private Sub Worksheet_Change(ByVal target As Range)
If target.Address = "$E$9" Then Call MyMacro
End Sub
---------