title: VBA-Excel Converting "FALSE" string to "False"
body: <p>This problem is driving me crazy! I have the following VBA Excel code:</p>
  
  <pre><code>Sub Test()
  
  Dim sTempVal As String
  
  For i = 1 to 100
      sTempVal = ActiveSheet.Cells(i, 1).Value
      MsgBox sTempVal
  Next i
  </code></pre>
  
  <p>As it is looping down the values in the first column, if it comes across the value FALSE or the value TRUE, it automatically reads it in as "False" or "True". Why is VBA changing the case automatically?? I really need it to retain the exact case of that value in the cell. I thought that by Dim'ing the sTempVal variable as a string, it would just read in the value in the cell - case and everything. Note that this ONLY applies to FALSE and TRUE. Any other value will be read in exactly as it appears in the cell.</p>