How to ignore case in string comparison

Question

I have an Excel VBA formula:-

If [G56] = "Not Applicable" Then
    ...

It is case-sensitive. I want it to ignore the case of "Not applicable".

Answer 1

You can just use the LCase function:

If LCase([G56]) = "not applicable" Then

Answer 2

You can also use the dedicated function for comparing strings:

Dim result As Integer

'// vbTextCompare does a case-insensitive comparison
result = StrComp("Not Applicable", "NOT APPLICABLE", vbTextCompare)

If result = 0 Then
    '// text matches
End If

There is some more information on the StrCompare method in this MSDN article