title: How to VBA change cell's value (display text) without changing its formula?
body: <p>I've a problem with this VBA macro.</p>
  
  <pre><code>Sub demoChangeText()
      Application.Range("B2").Value = "Overidden text"
  End Sub
  </code></pre>
  
  <p>My test is <a href="https://dl.dropbox.com/u/60740207/TestChangeText.xlsm" rel="nofollow noreferrer">here</a>. To run this macro, open it in Excel, press <code>Ctrl+F8</code> and choose <code>demoChangeText</code>.</p>
  
  <p>As the result, this macro changes the value of cell <code>B2</code> (the text displayed to us) but clear its formula. I need to change <code>B2</code>'s value BUT also need the formula to be remained.</p>
  
  <p>So my question is <strong>How to change the display text of cell without changing its formula?</strong></p>
  
  <p><em>UPDATE</em></p>
  
  <p>I ask this question because I'm trying to solve <a href="https://stackoverflow.com/questions/11431677/how-to-vba-sends-a-async-xmlhttp-request">this problem</a></p>