Search
Close this search box.

VBA Introduction


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.

Concatenation operators: Concatenation operators join multiple strings into a single string.

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.