Writing Word Macros, Second Edition

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	^
	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	<= or =<
	Greater than or equal to	>= or =>
	Not equal to	<> or ><

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"