Scribd
Upload
9 views

VBA - Operators

Uploaded by

jaspinders507
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views

VBA - Operators

Uploaded by

jaspinders507
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Page 1 of 3

VBA - Operators
An Operator can be defined using a simple expression - 4 + 5 is equal to 9. Here, 4 and 5 are called
operands and + is called operator. VBA supports following types of operators −

Arithmetic Operators
Comparison Operators

Logical (or Relational) Operators


Concatenation Operators

The Arithmatic Operators


Following arithmetic operators are supported by VBA.

Assume variable A holds 5 and variable B holds 10, then −

Show Examples

Operator Description Example

+ Adds the two operands A + B will give 15

- Subtracts the second operand from the first A - B will give -5

* Multiplies both the operands A * B will give 50

/ Divides the numerator by the denominator B / A will give 2

% Modulus operator and the remainder after an integer division B % A will give 0

^ Exponentiation operator B ^ A will give 100000

The Comparison Operators


There are following comparison operators supported by VBA.

Assume variable A holds 10 and variable B holds 20, then −

Show Examples

Operator Description Example


Page 2 of 3

Checks if the value of the two operands are equal or not. If yes,
= (A = B) is False.
then the condition is true.

Checks if the value of the two operands are equal or not. If the
<> (A <> B) is True.
values are not equal, then the condition is true.

Checks if the value of the left operand is greater than the value
> (A > B) is False.
of the right operand. If yes, then the condition is true.

Checks if the value of the left operand is less than the value of
< (A < B) is True.
the right operand. If yes, then the condition is true.

Checks if the value of the left operand is greater than or equal to


>= (A >= B) is False.
the value of the right operand. If yes, then the condition is true.

Checks if the value of the left operand is less than or equal to the
<= (A <= B) is True.
value of the right operand. If yes, then the condition is true.

Explore our latest online courses and learn new skills at your own pace. Enroll and become a certified
expert to boost your career.

The Logical Operators


Following logical operators are supported by VBA.

Assume variable A holds 10 and variable B holds 0, then −

Show Examples

Operator Description Example

Called Logical AND operator. If both the conditions are


AND a<>0 AND b<>0 is False.
True, then the Expression is true.

Called Logical OR Operator. If any of the two conditions


OR a<>0 OR b<>0 is true.
are True, then the condition is true.

Called Logical NOT Operator. Used to reverse the logical


NOT state of its operand. If a condition is true, then Logical NOT(a<>0 OR b<>0) is false.
NOT operator will make false.

Called Logical Exclusion. It is the combination of NOT and


XOR OR Operator. If one, and only one, of the expressions (a<>0 XOR b<>0) is true.
evaluates to be True, the result is True.

The Concatenation Operators


Page 3 of 3

Following Concatenation operators are supported by VBA.

Assume variable A holds 5 and variable B holds 10 then −

Show Examples

Operator Description Example

+ Adds two Values as Variable. Values are Numeric A + B will give 15

& Concatenates two Values A & B will give 510

Assume variable A = "Microsoft" and variable B = "VBScript", then −

Operator Description Example

+ Concatenates two Values A + B will give MicrosoftVBScript

& Concatenates two Values A & B will give MicrosoftVBScript

Note − Concatenation Operators can be used for both numbers and strings. The output depends on the
context, if the variables hold numeric value or string value.

You might also like