title: Case-Insensitive String Comparison
body: <p>I'm trying to find a way to show the MsgBox if those two strings are equal but doesn't look at upper- or lowercase.</p>
  
  <pre><code>For teller = 1 To 51
  If Cells(teller, 5).Value = Me.txtGebruikersnaam Then
      MsgBox ("Deze Gebruiker bestaat al!")
      Exit Sub
      Else
  End If
  Next
  </code></pre>
  
  <p>I tried to use:</p>
  
  <pre><code>If (StrComp(Cells(teller, 5).Value = Me.txtGebruikersnaam, vbTextCompare) = 0) Then
  </code></pre>
  
  <p>but it didn't work.</p>