I'm sorry as this is my third post relating to the same topic but I still haven't found a solution. What I’ve got is:
If Target.Column = Some Value Then
If Target.Value >= Some Value Then
Do what I need to do
End If
End If
I'm using this with a DDE linked spreadsheet and I want to evaluate the change of a linked cell. Problem is I can’t use the DDE linked cells as my Target nor can I use a formula in another cell that references the DDE linked cell. Neither fires the Worksheet_Change event. The Worksheet_Calculate event might work but there would be too much overhead in finding the cell that meets the criteria as this sheet is updated constantly.
I would greatly appreciate any suggestions!!
Thanks - Dave
If Target.Column = Some Value Then
If Target.Value >= Some Value Then
Do what I need to do
End If
End If
I'm using this with a DDE linked spreadsheet and I want to evaluate the change of a linked cell. Problem is I can’t use the DDE linked cells as my Target nor can I use a formula in another cell that references the DDE linked cell. Neither fires the Worksheet_Change event. The Worksheet_Calculate event might work but there would be too much overhead in finding the cell that meets the criteria as this sheet is updated constantly.
I would greatly appreciate any suggestions!!
Thanks - Dave