VBA provides many operators, which can be used to implement complex operations. Today, the author will share the **basic operators** and operations provided by VBA, and their basic usage.

VBA operators can be divided into the following 6 categories:

- Assignment operator
- Arithmetic Operator
- Comparison operator
- Logical Operators
- Concatenation operator
- Other operators

### Assignment Operator

The first is the most basic, the assignment operator (= ). In the VBA variable article, the core of the assignment syntax is = (equal sign), the variable is on the left, and the data is on the right. It can be understood that the variable is equal to the assigned data.

### Arithmetic Operator

Arithmetic operators are commonly used mathematical operators, including addition, subtraction, multiplication, and division. The complete arithmetic operators in VBA are as follows.

Assuming a = 10, b = 3, -> means the result.

### Comparison Operator

Comparison operator, this operator will compare the two variables provided, if the comparison conditions are met, it returns True, otherwise, it returns False.

Assuming a = 10, b = 3, -> means the result.

### Logical Operators

Logical operators perform logical operations on logical values, namely True and False, and return the result of the operation, which is also a logical value.

Assuming a = True, b = False, -> means the result.

### Concatenation Operator

The concatenation operator in VBA is used to concatenate two or more texts. Its usage is the same as the & symbol in Excel formulas.