How to Check Multiple Conditions in an If Statement in VBA

In this tutorial, we will show you how to check multiple conditions in an If statement in VBA (Visual Basic for Applications). “If” statements in VBA are quite flexible and powerful tools for controlling the flow of your code. Particularly, multiple conditions in an If statement allow you to test different conditions and perform different actions depending on the results of these tests.

Step 1: Understanding If-Then-Else Statements

The usual syntax for an If-Then statement is:

But often, we need our program to be smarter and to be able to make choices between more than two options. That’s when we would use an If-Then-Else statement. The syntax is:

Step 2: Checking Multiple Conditions

To check multiple conditions in an If statement, you can use the logical operators “And” & “Or”.

Here’s an example of using “And” operator:

And an example using “Or” operator:

Step 3: Applying Multiple Condition Check in an Example

Let’s consider an example with multiple conditions:
Assume we have a variable, score, and want to check if it’s greater than 50 AND less than 80. We can build an If-Then-Else statement using the AND operator to check these conditions:

This code will display the message “Score is between 50 and 80” because a score of 75 meets both conditions.


Checking multiple conditions can improve the logic of your code, making your VBA applications more flexible and dynamic. By applying the AND and OR logical operators in your If-Then-Else statements, you can abstract even more complex logical reasoning into your code.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.

Posted in vba