Comparison operators compare two expressions, as you found out in Chapter 4 when we discussed making decisions in VBA.
MsgBox 3 > 1
This returns True because 3 is greater than 1.
Comparison operators always return a Boolean value of True or False except when Null is included, in which case the result is always Null. Here is a list of comparison operators:
Operator | Meaning |
---|---|
< | Less than |
<= | Less than or equal to |
> | Greater than |
>= | Greater than or equal to |
= | Equal to |
<> | Not equal to |
If both expressions are numeric, then a numeric comparison is performed. If they are both string expressions, then a string comparison is performed. If one is numeric (the variable is a numeric type containing a number) and one is a string (a variable containing a string of characters ), then a Type Mismatch error will occur.