VBA Comparison Operators

VBA comparison operators are used to compare values in VBA and Macros for Excel.

List of VBA Comparison Operators

Comparison Operator Examples

Each example uses an IF statement to compare the values A and B and it will then output a message depending on the result of the comparison.

The part to pay attention to comes between the If and Then section of the code.

A < B

If A is less than B.

If A < B Then MsgBox "Hi!" Else MsgBox "Bye!"

A > B

If A is greater than B.

If A > B Then MsgBox "Hi!" Else MsgBox "Bye!"

A <= B

If A is less than or equal to B.

If A <= B Then MsgBox "Hi!" Else MsgBox "Bye!"

A >= B

If A is greater than or equal to B.

If A >= B Then MsgBox "Hi!" Else MsgBox "Bye!"

A = B

If A is equal to B.

If A = B Then MsgBox "Hi!" Else MsgBox "Bye!"

A <> B

If A is not equal to B.

If A <> B Then MsgBox "Hi!" Else MsgBox "Bye!"

Notes

Comparison operators are pretty straightforward but it does take a little time to get used to using them.

Bookmark this guide for future reference.

Download the file attached to this tutorial for the VBA code in Excel.