An operator is an element that performs an operation on one or more code values.
Relational operators are used to compare values and are evalated from left to right.
If you type in "=<" or "=>" then it will be automatically changed to ">=" or "<=".
These are listed in order of precedence.
|\||Division with Integer result|
|Mod||Modulo (remainder after division)|
|=||Equal and Assignment|
|<>||Not Equal To|
|<= or =<||Less Than or Equal To|
|>= or =>||Greater Than or Equal To|
|OR||Or - always evaluates both regardless|
|XOR||Exclusive OR (one or the other, but not both)|
|EQV||Equivalence (they must both be the same)|
|IMP||Implication (if one is true then the other must be true)|
|TYPEOF||Returns the object data type|
AndAlso and OrElse
These are not available in VBA (only VB.Net).
© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited