VBScript in a Nutshell

Appendix C. Operators

There are four groups of operators in VBA: arithmetic, concatenation, comparison, and logical. You’ll find some to be instantly recognizable and familiar, while others require a much deeper understanding of mathematics that goes beyond the scope of this book. However, if you have the need to use these types of operators, it is likely that you know the mathematics fundamentals behind them. We will look at each group of operators in turn before discussing the order of precedence VBA uses when it encounters more than one type of operator within an expression.

Arithmetic Operators

+

The addition operator. Used to add numeric expressions, as well as to concatenate (join together) two string variables. However, it’s preferable to use the concatenation operator with strings to eliminate ambiguity.

Example: result = expression1 + expression2

-

The subtraction operator. Used to find the difference between two numeric values or expressions, as well as to denote a negative value. Unlike the addition operator, it cannot be used with string variables.

Example: result = expression1 - expression2

/

The division operator. Returns a floating-point number.

Example: result = expression1 / expression2

*

The multiplication operator. Used to multiply two numerical values.

Example: result = expression1 * expression2

\

The integer division operator. Performs division on two numeric expressions and returns an integer result (no remainder or decimal places).

Example: result = expression1 ...