title: Clear contents of active cell if it contains specific text
body: <p>I am trying to develop an excel based tool, wherein I have put the default answer to my questions as 'enter comments'. I would like to set up a code where, when the user clicks on the answer cell, the text 'enter comments' disappears, and it becomes a blank cell. However, once the user has entered his answer, the cell should not be cleared - the answer text should remain. </p>
  
  <p>I have tried a host of VBA codes for this problem. While none throw up any error, none of them work either. Below is an example of the code I have tried:</p>
  
  <pre><code>Sub Macro1()
  Dim text as String
  text = "Enter comments"
  If ActiveCell = text then
  ActiveCell.ClearContents 
  End if
  End sub
  </code></pre>