A simple expression can be used to define an operator – 9 + 6 = 15. 9 and 6 are referred to as operands, while + is referred to as an operator. VBA supports the following types of operators.
Arithmetic Operators
Comparison Operators
Logical (or Relational) Operators
Concatenation Operators
Arithmetic Operators: Arithmetic operators in computer science are symbols or functions that execute mathematical operations including addition, subtraction, multiplication, division, and exponentiation. These operations allows manipulation and calculation of numbers.
Comparison Operators: Comparison operators are able to evaluate and compare strings or numbers.
Logical Operators: Logical operator that performs a logic operation on nodes, groups, or numbers.
Note: Concatenation operators can be used for both numbers and strings. The output depends on the context as well as whether the variables include numeric or string values.