Worksheet_Change doesn't fire up when streaming live data

Question

I have read many posts around this topic, however nothing seems to work for my scenario

I would like to Call Sub upon cell change (B2) which contains live data feed from external source -last updated:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Target.Worksheet.Range("B2")) Is Nothing Then
        Call SubName
    End If
End Sub

I went through numerous posts suggesting to check if Äpplication.EnableEvents = True, or create function to detect the change ( which does work, however I cannot call sub within function) - with no success.

Interestnigly enough, when I click on B2 and press enter - it executes the sub

Thanks

Answer 1

Say cell A1 is updated by streaming. The update will not trigger either:

• Worksheet_SelectionChange
• Worksheet_Change

What you need to do is setup an equation somewhere:

=A1

When A1 is refreshed, the formula cell will re-calculate and you can detect it with the Calculate Event.

Answer 2

you can simply go

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$B$2" Then SubName
End Sub