Hey guys, welcome back. So so far, we've seen that the only way to exit a for loop is to actually reach the end for the counter, or to reach the last pass in the loop or the last iteration. So for example, for x equals one to 10, that means that the loop will not end unless we reach x to be equal to 10. We do the 10th pass or the 10th iteration through the loop. However, there is another way that you can exit a for loop at any point in the loop using the exit for statement. Now we're going to have an example here.

And although it's a trivial example, it represents the case when you want to exit a for loop based on a certain condition and you will not know when this condition is going to be satisfied or at which iteration it could be satisfied on the first iteration on the 10th edition. If you don't know, he just want to exit the loop when this condition is satisfied, okay? So this macro here that we're going to have is going to represent that case. So let's go through the macro here and know what it does. So basically, on column x here, I've put the values one 230 in cells x one, two X 30. The first step in this macro is that it's going to determine what the last row in column x is, which is going to be row number 30.

And then it's going to say for i equals one to LR and is basically our counter. And our LR is going to be 30 at all times because the last row and column x is 30. That is something that will not change. First of all, we're going to generate a random number and this random number is going to be an integer between wean one and the value of the LR, which is basically 30. And I don't need you to worry about the formula for generating this random number. Okay, I just want you to focus on the fact that this formula would just generate a random number between one and the value of LR, which is 30.

And then we're basically going to start selecting the cell based on the iteration loop. So we're going to select cells on E comma 24. So basically, if we're in the first iteration, we're going to select cell x one, if we're in the second iteration, we're going to select cell x two, and so on and so forth. And then we're going to test if the value of the active cell is equal to the random number. And if that's the case, we're going to get a message box that says we reached our goal after our iteration. So we're just going to report that we reached our goal after our iterations Actually, it is going to be the number of the iteration basically.

So this is why we put a variable for for this because we don't know when we're going to reach our goal. And our goal is to basically have the value of the active cell equal to the random number that we generated that is between one and 30. And then we're going to exhibit four and this exit for statement, what it does is it exits the for next loop. And it works with a for each loop as well that we're going to see in the future. So it's going to exit it and execute any statement after it. which in our case series just going to be the N sub statements so as to exit the macro.

However, what happens if we don't reach our goal? So if we go through all the 30 cells, and we test the values in the 30 cells against the random number, and we never have a random number equal to the value of the current active cell, we're gonna have a mess. Box, we haven't reached our goal with a sad face here. And then at this point, because we're going to have to be equal to the value of the last row or it to be equal to 30, we're going to have all our iterations finished. So we're basically going to end if and actually, there won't be any more pauses or iterations on the loop to do. So we're going to execute any statement after the for next loop, and it's going to be the end sub statement, and we're just going to exit the macro.

So here the purpose of this macro to this procedure is to show you the scenario when you're going to do a loop and you want to exit the loop based on a condition but you don't know when this condition is going to be satisfied. And hence, this is why we're generating a random number. Okay, so as to have the condition be satisfied at a point that you don't know when it's going to be satisfied. Okay, so you don't know on which pass loop or which iteration you're gonna have your condition satisfied. And this is why you're using these that for you testing for condition. And when it says fine to use the exit for statement.

So let's start executing the macro here, I'm going to go through it step by step by using f8 on my keyboard. So here, I'm going to get the value of the last row to be equal to 30. And then here is going to be for i is equal to one to 30. So we're going to do 30 passes on this for next loop. However, we might exit if we satisfy our condition before the 30th pass or the 33rd iteration. So now we're going to generate a random number is trying to remember is 25.

And we're going to select cells i comma 24, which in this case, because is equal to one, it's going to be cell x one, and then we're going to test is the value of the active cell equal to the random number. The value of the active cell is one and the value of the random number is equal to 25. So they are not equal and are we on the last iteration? No, we're not. So what are we going to do? We're just going to go into another pass on the loop.

We're going to generate another random number. It's 25 as well. So we're going to test is equal to the value of the active cell. No, it is not. So we're going to do it again and keep Pon doing. Now the active cell here is four and random numbers.

30. So no active cells five and random numbers. 28. So no, six and seven. No, they're not equal. Seven and 21.

They are not equal nine and eight. They are not equal 11 and four, so we're going to keep on doing that until they become equal, and they're still not equal on any pass. See, you guys the randomness factor here. We're generating a random number and we don't know on which pass, we're going to have to exit the loop 23 and 10 No, they're not equal. So here, we have not reached our goal, we've done 30 passes, and we could not get the value of the active cell to be equal to the random number. So we can execute the macro again.

And it says again, here, also 30 passes, we have not reached our goal. And here we reached our goal after 11 iterations. So you can see here that after 11 iterations, we've managed to have a random number equal to the value of the active cell. And what happened here is that it messagebox reached our goal after 11 iterations got executed and then we executed the exit for statement and we exited the loop basically, and we executed the unsub which ends our macro, okay, so this macro, although it is trivial, it's a trivial example, over illustrates the randomness factor when you want to exit a loop but you You don't know on which iteration you're going to need to exit that loop. So I hope that illustrates the exit for statement for you. It is used to basically exit your loop at any point.

And you can use it with a condition to exit the loop because you don't know on which iteration exactly, you're going to need to exit the loop. This is where you put a condition and based upon that, you execute the exit for statement and you exit the loop. Okay, so I hope that was informative for you. Thank you very much for watching this video and I'll see you on the next one.