title: In VBA get rid of the case sensitivity when comparing words?
body: <p>I am working on an VBA program which would allow the user to type an address and find the location by matching elements of the address with a database. </p>
  
  <p>Unfortunately, I am having a recurrent problem with the case sensitivity. </p>
  
  <p>For example, when I am using this code :  </p>
  
  <pre><code>For i = 11 To lRowB
  Range("B" &amp; i).Activate
  myResult = IsNumeric(Application.Match(ActiveCell.Value, manilaListRange, 0))
  </code></pre>
  
  <p>It is gonna compare the value of the active cell to a list of words from my database. Problem is, if in my active cell the word is "miami" or "MIAMI" and only "Miami" is in the database, it won't work...</p>
  
  <p>Other example:  </p>
  
  <pre><code>If Range("J6").Value = "tawi" Then
  Range("J6").Value = "Tawi-Tawi"
  End If
  </code></pre>
  
  <p>Same problem, only the word written with the same case is gonna work.</p>
  
  <p>How can I get rid of this? It's particularly annoying and I can't rewrite my database in every case combination possible! </p>
  
  <p>Thanks in advance !</p>