Using the StrComp Function to Compare Apples to Apples : StrComp « String Functions « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. String Functions
3. StrComp

Using the StrComp Function to Compare Apples to Apples

 
'StrComp(string1, string2 [, compare])(vbTextCompare) or binary comparison (vbBinaryCompare).

Sub strDemo()
    Dim Pet As String
    Pet = "dog"
    If StrComp(Pet, "dog", vbTextCompare) = True Then _
        MsgBox "We do not accept dogs."
End Sub

 

Related examples in the same category