When you compare 2 Strings for Case insensitive cases use
Option Compare Text at the top of the sub procedure.
One small example
Option Compare Text
Sub check()
If ("A" = "a") Then
MsgBox "Case insensitive"
End If
End Sub
Option Compare Text at the top of the sub procedure.
One small example
Option Compare Text
Sub check()
If ("A" = "a") Then
MsgBox "Case insensitive"
End If
End Sub
No comments:
Post a Comment