VBA Operators

VBA uses a handful of simple operators and relations, the most common of which are shown in Table 5-5.

Table 5-5. VBA Operators and Relations

Type

Name

Symbol

Arithmetic Operators

Addition

+

Subtraction

-

Multiplication

*

Division

/

Division with Integer result

\

Exponentiation

A

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"

0 0

Post a comment