Operators

Variables can be manipulated in VBA using assignment, arithmetic, relational, and logical operators.

• The assignment operator is used to assign a value to a variable or constant (that equals this).

• Arithmetic operators are used to mathematically manipulate numeric variables and numbers (addition, subtraction, multiplication, division, etc.).

• Relational Operators are used to compare the relationship between variables (less than, greater than, not equal to, etc.).

• Logical operators are used to perform digital logic operations on variables ( AND, OR, NOT, etc.).

When using multiple operators in a VBA statement, you need to ensure the proper execution of your code by observing order of precedence rules.

The string concatenation operator is used to join strings together.

See Also

Constants

Variables

Numbers

Strings

Date and Time Handling

VBA Function Reference