Excel VBA IF THEN Statement is one of the most useful statements in VBA. In this tutorial, you’ll quickly learn how to work with the IF, THEN, ELSE, ELSEIF as well as the AND statements. This way you can write Excel macros that are dependent on multiple conditions.

The IF-THEN-ELSE statement can only be used in VBA code in Microsoft Excel. Let's look at some Excel IF-THEN-ELSE statement function examples and explore how to use the IF-THEN-ELSE statement in Excel VBA code: First, let's look at a simple example. LRegionName = "North" Next, let's look at an example that uses ElseIf. LRegionName = "North"

Read More: How to Use IF Function with OR and AND Statement in Excel The basic syntax for an ..Then…Else statement in VBA is: “If condition Then statement1 Else statement2”. Here the condition is a logical expression that evaluates to either True or False.

We have three different types of IF statements in VBA. 1. IF-Then IF THEN is the simplest form of an IF statement. All we need to do is specify a condition to check and if that condition is TRUE it will perform a task. But, if that condition is FALSE it will do nothing and skip the line instantly.