CodeItBetter Programming Another VB Programming Blog

'String Manipulation - Compare two strings (case insensitive)
Dim strString1 As String, strString2 As String
strString1 = "Abc"
strString2 = "abc"
If LCase$(strString1) = LCase$(strString2) Then
    MsgBox "Same value"
Else
    MsgBox "Not the same value"
End If
 
'Or

Dim strString1 As String, strString2 As String
strString1 = "Abc"
strString2 = "abc"
If StrComp(strString1, strString2, vbTextCompare) = 0 Then
    MsgBox "Same value"
Else
    MsgBox "Not the same value"
End If