title: Trigger VBA Word macro based on Cell change Value
body: <p>Hi I need to trigger a macro in vba based on its value being changed by .Net application. For eg I have the following template
  <a href="http://i.stack.imgur.com/CaF5s.png" rel="nofollow">Template populated by .Net application</a></p>
  
  <p>I have the following code that needs to do substring on Cell(3,1) when it's value gets populated.</p>
  
  <pre><code>Sub Format()
  Dim Str1 As String
  Dim Str2 As String
  
  tbl = ActiveDocument.Tables(1)
  Str1 = tbl.Cell(3, 1).Range.Text
  Str2 = Split(Str1, " ")(0)
  tbl.Cell(3, 1).Range.Text = Str2
  
  End Sub
  </code></pre>
  
  <p>The issue is this needs to be triggered when value in Cell(1,3) changes from &lt;> to "This is Heading Three"</p>