StrComp Function Description
The VBA StrComp function compares two strings, and returns the result of this comparison as an Integer representing the result of a string comparison.
Syntax
The syntax for the StrComp function in VBA is:
1 | StrComp ( string1, string2 [, compare ] ) |
Parameters
string1
First string to be compared.
string2
Second string to be compared
compare
Optional. The type of comparison to be performed. VBA Constant values:
Constant | Value | Description |
---|---|---|
vbUseCompareOption | -1 | Uses option compare |
vbBinaryCompare | 0 | Binary comparison (distinguishes letter case) |
vbTextCompare | 1 | Textual comparison (ignores letter case) |
Other Notes
Condition | StrComp Function Result |
---|---|
string1 sorts ahead of string2 | -1 |
string1 is equal to string2 | 0 |
string1 sorts after string2 | 1 |
string1 or string2 is equal to Null | Null |
Example usage
The StrComp function can be used in VBA code. Let’s look at some VBA StrComp function examples:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | StrComp "Hello" , "Hello" 'Result: 0 - string1 is equal to string2 StrComp "Hello" , "hello" 'Result: -1 - string1 sorts ahead of string2 StrComp "Abc" , "Bcd" 'Result: -1 - string1 sorts ahead of string2 StrComp "Bcd" , "Abc" 'Result: 1 - string2 sorts ahead of string1 StrComp "Hello" , Null 'Result: Null |