When this occurs, script execution will continue after the current loop. This will exit or break out of a While loop. Simply put this in the place where you want to exit the loop. If there are nested For loops, only the one directly containing the Exit statement will be broken out of and execution of the script will continue with the next containing For loop. This will exit or break out of a For loop, which includes a For.Next loop and a For Each.Next loop. If there are Do loops nested within Do loops, only the one directly containing the Exit statement will be broken out of and execution of the script will continue with the next containing Do loop. This will exit or break out of a Do loop, including Do While and Do Until loops.

Sections:īreak out of a Loop when a Condition is Met This tutorial includes breaking out of While, Do, and For loops. Grade.Offset(0, 1).How to Exit, End, or Break out of loops in Excel. Grade.Offset(0, 1).Value = 'Needs Improvement' So a grade of 'A' or 'B' will have a corresponding comment value of 'Great Work', a grade of 'C' will have a comment of 'Needs Improvement', and all other grades will have the comment 'Time for a Tutor'. We want to update the comment value in column C based on the grade in column B. In the second video example, we have a list of students in column A and their corresponding grade in column B. If we entered 'S' in cell A2, we want 'South' to appear in cell C2, and so on. So if we entered 'N' in cell A2, we want 'North' to appear in cell C2. In the first video example, we are going to use the IF-THEN-ELSE statement to update cell C2 with 'North', 'South', 'East' or 'West' depending on the region code entered in cell A2. If LRegion ='N' Thenįinally, let's look at an example that uses Else. Next, let's look at an example that uses ElseIf. 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:įirst, let's look at a simple example. The IF-THEN-ELSE statement can only be used in VBA code in Microsoft Excel.

Visual basic for excel for loop