In this video, we're going to discuss the if then else if structure. So the if then else if structure allows you to test not only one condition, as we've seen before, on the if then else and the simple if statement, but actually, it allows you to test multiple conditions and have multiple codes that will result from any of these conditions being true, you can add as many conditions as you like using the else if statement. So basically, the structure of the if then else if is basically if a condition is equal to true, which is normal. If you know you're gonna have some code resulting from that, and then you're going to write an else if, then else if, and then you're going to put a condition. And this else if condition just says that there is a condition is just a normal condition. It's nothing special, and then you're going to test this condition is equal to true, and then you're going to put it then and then you're going to have some code that is going to be executed.

If that condition is true, you can also put another elsif with another condition here testing that is true. And if that condition is true, you're going to execute another set of code. And you can put any number of elsif statements. So here we've got elsif, else if condition N and N means that you can put any number of elsif statement so you could put a first elsif statement, another elsif statement, a third one a fourth one, you can put any number of elsif statements and test any number of conditions. And if any of them is true, then the code corresponding to that condition or the code under that condition is going to be executed. And you can also put an else and the else here gets executed if none of the conditions none of the conditions for the if or the else if is true.

If that's the case, then whatever code under the else gets executed and the aliens series actually optional. So you can have an if then else if, without having the else part here, okay, so this can be deleted, this is optional. And you need to make sure to put an end if, of course, so the if then else if structure allows you to put any number of conditions that you like, and you can also put an else and this else gets executed if none of the conditions tested is true. And please note that if any of the conditions tested is true VBA will jump to the end if statement after executing its code. So for example, if we're testing conditions and the condition for the first elsif statement is true, what will happen is that else if code one is going to be executed, and then VBA will jump straight to the end if statement and execute any code after it will not test the rest of the conditions.

Okay, so Once a condition is found to be true VBA exits the if then else structure and goes to the end if and executes any code after it. Okay? So let's have an example for the if then else if structure. Okay guys, so now we're gonna have an example for the if then else if statement. So basically we've got a very simple example we've got here cell B 18, having a value, and we've got an if then else if structure here that I've written. And basically this structure tests the value in cell B 18.

So on the first line here on the if condition is going to test if it is a one, and if it's found to be true, then it's going to display a message box that says one. If it's not true, then it's going to go on and test on the on this else if line here it's gonna test if it's a two If that's the case, x is going to display a message box that says to, however, if it does not find it to be true, is going to test using the second else if here if the value is three, and if that's the case, it's going to display a three. And if it's not three is going to test if it's a four, and if it is, then it's going to display message boxes for If not, then it's just going to execute the else which is going to have a message box saying other value.

So let's step through the code step by step. Currently, the value is a one. So if you press f8 on your keyboard and start stepping through the code here, it's going to test here if the value is a one, and it's going to be true, so we're going to display a message box that says one and then notice how it actually jumps straight away to the end if line of code here because when it finds the certain condition is true, it doesn't test the other condition. It actually jumps straight away to the end if and starts executing any code after the end if statement. If we put a two here and test it. So basically it's going to test if the value is a one, it's not going to be a one it's going to test.

If it's up to you using this else if condition here, and if that's the case, yes, it is going to display a message box two, and then it jumps straight away to and if and if we actually put a five in here, which is not equivalent to any of the conditions that are going to be tested, you're going to see here that is going to test all the conditions and it's going to find them to be false. So it's going to execute actually the else statement here and it's going to display a message box that says other value. Also, I want to show you the part when I told you that the L statement is actually optional. So Want to run the code without the L statement. And you can see here that the value here in cell B 18 is a five. So it's not going to meet any of these conditions.

So what's going to happen in that case is that it's going to test all the conditions. And it's going to find them to be false. So it's gonna end if it's going to go to the end if statement because there's no else and then it's going to execute anything after the if statement. So in that case, we did not take any action based on any of the conditions because none of the conditions were true. Okay, so that's it, guys for the F then else if structure. Thank you very much for watching this video.

I'll see you on the next one.