title: Workbook_SheetChange not triggered by change from formula in other worksheet
body: <p>I'm trying to imlpement a code that displays a message when a certain condition is met. In this case, it should happen when <code>Sheet2's A1's</code> value is equal or bigger than 1000. This value, on the other hand, is defined by a formula located in <code>Sheet1</code>. I tried implementing a solution based on this thread: <a href="https://stackoverflow.com/questions/4388279/how-can-i-run-a-vba-code-each-time-a-cell-get-is-value-changed-by-a-formula">How can I run a VBA code each time a cell get is value changed by a formula?</a> </p>
  
  <p>So I got this:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  Dim updatedCell As Range
  Set updatedCell = Range("A1")
  
  If Not Application.Intersect(updatedCell, Range("A:A")) Is Nothing Then
      If updatedCell.Value &gt;= 1000 Then
          MsgBox "Something requires attention"
      End If
  End If
  End Sub
  </code></pre>
  
  <p>When I change the value of <code>A1</code> through something from <code>Sheet2</code>, it works, but if for example I define it as <code>=Sheet1!A7</code>, and change <code>Sheet1's A7</code>, nothing happens.</p>
  
  <p>How could I make it work? </p>