VBA Operators
VBA uses a handful of simple operators and relations, the most common of which are shown in Table 10.5.
Table 10-5. VBA Operators and Relations
Type |
Name |
Symbol |
---|---|---|
Arithmetic Operators |
Addition |
+ |
Subtraction |
- | |
Multiplication |
* | |
Division |
/ | |
Division with Integer result |
\ | |
Exponentiation |
^ | |
Modulo |
Mod | |
String Operator |
Concatenation |
& |
Logical Operators |
AND |
AND |
OR |
OR | |
NOT |
NOT | |
Comparison Relations |
Equal |
= |
Less than |
< | |
Greater than |
> | |
Less than or equal to |
<= | |
Greater than or equal to |
>= | |
Not equal to |
<> |
The Mod
operator returns the remainder after
division. For example:
8 Mod 3
returns 2, since the remainder after dividing 8 by 3 is 2.
To illustrate string concatenation, the expression:
"To be or " & "not to be"
is equivalent to:
"To be or not to be"
Get Access Database Design and Programming, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.