VBA Syntax - Operators

Operators

An operator is an element that performs an operation on one or more code values.
Relational operators are used to compare values and are evaluated from left to right.
If you type in "=<" or "=>" then it will be automatically changed to ">=" or "<=".

AND	The logical "AND" operator (Boolean).
EQV	The bitwise comparison operator.
IMP	The logical implication from two values (Variant).
IS	Compares two object reference variables.
LIKE	The pattern matching operator.
MOD	Returns the remainder after division operator.
NOT	The logical "NOT" operator (Boolean).
OR	The logical "OR" operator (Boolean).
TYPEOF	The object data type.
XOR	The bitwise exclusion operator.

Bitwise Operators

AND - requires 2 arguments
NOT - requires 1 argument and reverses all bits
OR - requires 2 arguments
XOR - requires 2 arguments

Numbers converted to Bits
1 = 1
2 = 10
4 = 100
8 = 1000
16 = 10000
22 = 10110
87 = 1010111