VBA StrComp function

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

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.


The syntax for the StrComp function in VBA is:

StrComp ( string1, string2 [, compare ] )


First string to be compared.

Second string to be compared

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:

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

Simply the best place to learn Excel VBA