Take a Guess to Win Windows 10 Pro Key!   # VBA Operator Basic Excel Formulas Tutorial

Date：2020-11-20

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.

### Other Operators

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.