Operator Precedence
- Last UpdatedJul 18, 2023
- 1 minute read
The operator precedence in VBA runs like this:
|
Operator |
Description |
Order |
|---|---|---|
|
( ) |
Parenthesis |
Highest |
|
^ |
Exponentiation |
|
|
- |
Unary minus |
|
|
/, * |
division/multplication |
|
|
Mod |
Modulo |
|
|
+, -, & |
addition, subtraction, concatenation |
|
|
=, <>, <, >,<=,>= |
Relational |
|
|
Not |
Logical negation |
|
|
And |
Logical conjunction |
|
|
Or |
logical disjunction |
|
|
Xor |
logical exclusion |
|
|
Eqv |
logical equivalence |
|
|
Imp |
logical implication |
Lowest |