Other than the assignment operator, VBA has several other operators.Other Operators
| Operator | What it does |
|---|---|
| + | Addition |
| - | Subtraction |
| * | Multiplication |
| / | Division |
| \ | Integer Division (the result is an integer given by the quotient) |
| ^ | Exponentiation |
| & | String Concatenation |
| Mod | Modulo arithmetic (returns the integer remainder after performing an integer division) |
| Logical Operator | What it does |
|---|---|
| Not | Performs a logical negation on a boolean variable or a boolean expression |
| And | Performs a logical conjunction on two boolean expressions |
| Or | Performs a logical disjunction on two boolean expressions |
| XoR | Performs a logical exclusion on two boolean expressions |
| Eqv | Performs a logical equivalence on two boolean expressions |
| Imp | Performs a logical implication on two boolean expressions |