Polar Studio

StrComp

Public Function StrComp(ByVal String_1 As String, ByVal String_2 As String, Optional ByVal Comparemode As Long = 0) As Long

Compares two strings and returns a number indicating the order of these strings: -1: String 1 < String 2, 0: String 1 and String 2 are equal, 1: String 1 > String 2

String_1: The first string to compare.
String_2: The second string to compare.
Comparemode: The way of comparing. Use vbBinaryCompare (0) for case sensitive or vbTextCompare (1) for case insensitive.

SendDebug StrComp("Bingo", "Bingo") 'Prints 0
SendDebug StrComp("bingo", "BINGO") 'Prints 1 
SendDebug StrComp("bingo", "BINGO", vbTextCompare) 'Prints 0, case insensitive, these are equal.

StrComp

Curious what we can do for you?