On this section of the course, we're going to speak about error handling in Excel VBA. So on the process of writing code in Excel VBA and developing applications, you are bound to get errors no matter what your skill level is as a developer. And on this video, we're going to have an introduction to error handling and excel vba. And we're going to learn about the different error types in Excel VBA. So in Excel VBA, we've got three main types of errors that you might encounter. We've got syntax errors, and we've got compile errors, and we've got runtime errors.

And to understand the difference between them, we need to understand how VBA checks our code when we write our code. So VBA does three types of checks when we write our code. The first type is syntax checks. And the second type is compile checks. And the third type is runtime checks. So first of all, starting with syntax checks, these syntax checks are basically like spelling and grammar checks if we relate that to English language.

So when VBA checks your code on this type of checks on syntax checks, it asks the question, does your code have any spelling or grammar mistakes, so it basically searches for any grammar or spelling mistakes on your code. So let's have an example. For example here, if you write workbooks, and then my workbook dot open, you will immediately if you write it this way, you will immediately get your code turn into red color. So why did our code turn into red color here? It's because we're having a spelling mistake, which Just basically not putting a second double quote, after the word, my workbook. So the word, my workbook needs to be enclosed in two double quotes, we've got only one double quote here on the left who don't have a closing double quote.

So this is in VBA. His book is basically a spelling mistake. And this is a syntax error. And you will get notified about this error by having your code highlighted in red. And this is because syntax checks are done in real time as you write your VBA code. So if you make any errors, you will get notified immediately by having your code turning into red.

The second type of checks is basically compiled checks. So compile checks, ask the question, does your code Make sense? So this is actually kind of the question that VBA asks about your code. Does your code make sense and this is done before Attempting to run your code. So before your code starts to run, and just after you hit the Run button, this check is done. And if you have an error, you will have an error that says compile error and you will have the error and your code will not start to run.

The third type of checks that get done on your code are basically runtime checks. One time checks, ask the question Can what you need to do be done and this is done when your code is running while executing each line of code. Okay, so let's have an example for each type of errors in Excel VBA. So starting with syntax errors, syntax errors are similar to spelling or punctuation errors in English language. So if you write in English, I love chocolate and you write the spelling of chocolate incorrectly as I did here, you're basically making a spelling mistake and this is similar to writing workbooks, my workbook without a closing double quote here, open, you made a spelling mistake, and your code will turn into red. Okay, so these are syntax errors.

Compilers are basically errors where you have your spelling and punctuation correct. However, the context that you're using the words in does not make sense. Remember, on compile check, we ask the question, does your code Make sense? So I'm going to have an example here in the English language. So if somebody tells you, I fly my car to work every day, okay, so this sentence, I fly my car to work every day does not have any spelling errors, and it does not have any punctuation errors. And it's grammatically correct.

However, this sentence does not make sense. Why. So what's the error? What's the problem? Well, the problem is cars cannot fly. Right?

At least not your average. car I mean, your average car does not fly, you probably could have seen a science fiction movie where cars fly. But for now, at least your average car for now does not fly, they could fly in the future. But for now, cars cannot fly. So we try to relate that to VBA. This error can happen when you write a word that exists in the VBA dictionary, however, using it in the wrong context.

So for example, if you write workbook, monk workbook dot open, so where is the problem here, so this would generate a compile error. Why? Because having the word workbook is not correct in this context, the word workbook does exist in the VBA dictionary. So VBA recognizes the word workbook and you will not get a syntax error. However, using it in this context is incorrect, because you should use work books not workbook. So this will really results in a compile error.

So how would you fix that, you need to make sure that you're using words in the right context. runtime errors result from something that can be done normally. So usually, this thing that you're trying to do can be done normally. But in this particular case, it could not be done. So this can result in a runtime error. And runtime errors result when you start running your code.

So actually, you will have your runtime error on a certain line of code that has a problem. Okay, so you will have it after your code starts to run. So to relate that we're not going to relate it to English language, because runtime errors are more about actions, not just words and languages will relate it to normal life or real life. So for example, if you try to drive your car with an empty gas tank, so driving up car is something that can be done normally. However, in this case, only, you cannot do it because you did not have any gas in the tank. So trying to do a valid action driving your car, it's a valid action.

It's something that can normally be done. However, it could not be done on this particular time, or in this particular occasion, because you did not have any gas in the tank. So in VBA, this can happen for example, if you're trying to select a worksheet that does not exist in your workbook. So for example, if you're right worksheets, my worksheet dot select, however, my worksheet does not exist in your workbook, you do not have a worksheet called my worksheet. So you will not get the error until you attempt to run this particular line of code that says worksheets my worksheet dot select so selecting the worksheet is a valid action, you just could not do it in this particular case, because the worksheet is not available in your workbook, then you will get a runtime error. So how can you fix that you need to make sure that what you're trying to do can be done plus apply error handling in case it cannot be done.

That is, if the worksheet does not exist, then write some code to create the worksheet before running that line of code that is going to make you select the worksheet for example. And this is what we're going to learn actually in this part of the course error handling, how to deal with errors, how to make sure that errors do not occur on your code. Okay, so this guy's was a quick introduction to error handling in Excel VBA. On the upcoming videos, we're going to dig deeper into error handling things Very much watching this video and I'll see you on the next one.