Skip to main content

Excel VBA Operator summary

Types Description Operators
Arithmetic operators Operators used to perform mathematical calculations. * operator
^ operator
/ operator
\ operator
Mod operator
+ operator
- operator
Comparison operators Operators used to perform comparisons. = operator
Is operator
Like operator
Concatenation operators Operators used to combine strings. & operator
+ operator
Logical operators Operators used to perform logical operations. And operator
Eqv operator
Imp operator
Not operator
Or operator
Xor operator

When several operations occur in an expression, each part is evaluated and resolved in a predetermined order called operator precedence. For more information, see Operator precedence.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>