Microsoft Office Tutorials and References
In Depth Information
There are three others that are perhaps less common:
\ : Integer division without rounding. For example, 15 \ 4 evaluates to 3.
^ : Exponentiation (to the power of). For example, 2^4 evaluates to 16.
mod : Modulus (remainder after division). For example, 33 mod 6 evaluates to 3.
For both division operators, a Divide by Zero error occurs if the divisor is 0.
The String Operator
There is one string operation called concatenation , which simply joins two strings together. The
operator for this is & . For example, after this code:
Dessert = “Chocolate “ & “cake”
the variable Dessert contains “Chocolate cake” . There are lots of other things you can do
with strings, but they involve functions rather than operators. You can find information on these
functions in VBA’s online documentation.
The Comparison Operators
You use comparison operators to perform comparisons between two expressions. The result of a
comparison is either True or False depending on whether or not the comparison was true. The most
commonly used comparison operators, which are used primarily with numeric expressions, are
= Is equal to?
> Is greater than?
< Is less than?
>= Is greater than or equal to?
<= Is less than or equal to?
<> Is not equal to?
For example, the expression
a < b
asks the question “is a less than b?” and returns either True or False depending on the values of a
and b .