help formula versus value

C

climax

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?:confused:

Thanks for helping
 
Top