title: Select Case not working when cell is formula-driven
body: <p>I try to write a code that shows different message box when cell A3 value is different. I find this code works when cell A3 contains text only, but when I try to make cell A3 as a formula-driven cell,this code below does not work. Can anyone help please???  </p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  If Not Application.Intersect(Range("A3"), Range(Target.Address)) Is Nothing Then
      Select Case Target.Value
          Case Is = "FALSE": MsgBox "This is False!"
          Case Is = "TRUE": MsgBox "This is True!"
      End Select
  End If
  End Sub
  </code></pre>