- VBA Tutorial
- VBA - Home
- VBA - Overview
- VBA - Excel Macros
- VBA - Excel Terms
- VBA - Macro Comments
- VBA - Message Box
- VBA - Input Box
- VBA - Variables
- VBA - Constants
- VBA - Operators
- VBA - Decisions
- VBA - Loops
- VBA - Strings
- VBA - Date and Time
- VBA - Arrays
- VBA - Functions
- VBA - Sub Procedure
- VBA - Events
- VBA - Error Handling
- VBA - Excel Objects
- VBA - Text Files
- VBA - Programming Charts
- VBA - Userforms

- VBA Useful Resources
- VBA - Quick Guide
- VBA - Useful Resources
- VBA - Discussion

- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who

# VBA - Logical Operators

Following logical operators are supported by VBA.

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

Operator | Description | Example |
---|---|---|

AND | Called Logical AND operator. If both the conditions are True, then the Expression is true. | a<>0 AND b<>0 is False. |

OR | Called Logical OR Operator. If any of the two conditions are True, then the condition is true. | a<>0 OR b<>0 is true. |

NOT | Called Logical NOT Operator. Used to reverse the logical state of its operand. If a condition is true, then Logical NOT operator will make false. | NOT(a<>0 OR b<>0) is false. |

XOR | Called Logical Exclusion. It is the combination of NOT and OR Operator. If one, and only one, of the expressions evaluates to be True, the result is True. | (a<>0 XOR b<>0) is true. |

## Example

Try the following example to understand all the Logical operators available in VBA by creating a button and adding the following function.

Private Sub Constant_demo_Click() Dim a As Integer a = 10 Dim b As Integer b = 0 If a <> 0 And b <> 0 Then MsgBox ("AND Operator Result is : True") Else MsgBox ("AND Operator Result is : False") End If If a <> 0 Or b <> 0 Then MsgBox ("OR Operator Result is : True") Else MsgBox ("OR Operator Result is : False") End If If Not (a <> 0 Or b <> 0) Then MsgBox ("NOT Operator Result is : True") Else MsgBox ("NOT Operator Result is : False") End If If (a <> 0 Xor b <> 0) Then MsgBox ("XOR Operator Result is : True") Else MsgBox ("XOR Operator Result is : False") End If End Sub

When you save it as .html and execute it in the Internet Explorer, then the above script will produce the following result.

AND Operator Result is : False OR Operator Result is : True NOT Operator Result is : False XOR Operator Result is : True

vba_operators.htm

Advertisements