title: Autorun Excel vba code when cell value changes
body: <p>I'm looking for a way to automatically start a certain Sub when the cell's value is Zero.</p>
  
  <p>E.g. if I enter "0" into Cell A1 the following Sub is supposed to run</p>
  
  <pre><code> Range("H32").FormulaR1C1 = "=SUM(R[-4]C:R[-2]C)"
  </code></pre>
  
  <p>And if I enter 1 (or any other Value above 0) into Cell A1 another Sub should run, e.g.</p>
  
  <pre><code>Range("B15").FormulaR1C1 = "=SUM(R[-1]C:R[-1]C)"
  </code></pre>
  
  <p>The calling of a Sub should happen right after I enter the value in excel, without pressing a button oder anything else.
  Is there any way to do this?</p>