Hi,

I´ve got a problem.
I get streaming forex data in cell i2
whenever the data changes I want to trigger a script to check something.
I used this script in vb worksheet to trigger it.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("i2")) Is Nothing Then
bla bla bla ect.

But it only reacts when the actual value changes like when I type something in cell i2. Since there is a formula in i2 to get the streaming data it won´t trigger it.

What am I doing wrong?

Thanks for helping