VB & VBA in a Nutshell: The Language

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 than both the scope of this book and my knowledge of math are able to offer. 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.