title: Best way in Excel VBA to listen for cell changes
body: <p>I'm trying to watch a cell for changes. The cell can change many times a second triggerd by some VBA code from a Add-in. I want to count the number of times the value updates.</p>
  
  <p>What I have so far is:</p>
  
  <pre><code>Private Sub Worksheet_Calculate()
      Static oldval
      If Range("C3").Value &lt;&gt; oldval Then
          oldval = Range("C1").Value
          Blad1.Range("N18").Value = Blad1.Range("N18").Value + 1
      End If
  End Sub
  </code></pre>
  
  <p>The issue is that when I start my Excel sheet the code crashes at once with the error: <code>Out of stack space</code></p>
  
  <p>My question is now why am I getting this error and is this the fastes implementation for what I want to do?</p>