Hey guys welcome back. So in this video we're going to discuss the error object and the error object a spelt er r allows us to know what error has been generated in our procedure, okay, and it allows us to know information about that error. So what the error number is what the description is, so that we can do different error handling based on the type of error that I have faced in my procedure. So let's have an example here I've got this procedure here and I've got two statements that are going to generate errors because the first one here, worksheets my worksheet does select is going to select the worksheet that is called my worksheet, which is actually not available in my workbook at the moment have deleted it. So this one is going to generate an error. And also the second statement is a division by zero so it's going to generate an error as well.

So let's run this procedure here step by step. So the first statement is gonna generate an error? runtime error number nine. Okay, so the urn number is nine, I'm gonna comment that first statement, okay, so that we do not run it and I'm gonna run on procedures. So now only the second statement is going to be run here, which is the division by zero. And notice here, that is runtime error number 11.

So the error number is 11 here, okay, so I'm just gonna remind myself that this or is nine, and this one is error number 11. Okay, so I put reminders here just for myself not to forgot. And now what I'm going to do is that I'm going to create here a go to labels on our go to for example, or handling and then I'm going to create a label here called error handling. And now we're going to test for the error number that's been generated. So if IRD number is equal to nine, then messagebox the worksheet called my worksheet does not exist please create it so this is the error message that's going to appear if the error is tested to be the one here for selecting the worksheet that's called my worksheet what actually does not exist and notice here how I put the my worksheet word here between two pairs of double quotes because this is how you're going to make the word my worksheet appear between two double quotes while actually being inside a string.

So being between double quotes as well when you see that you understand it else if IRD number is equal to 11, then so in this case, we have the divide by zero or division by zero error message box you cannot divide by zero and then and if Okay, so now we're gonna run our procedure. So here we have an error go to error handling. So this is gonna Take us through the label called error handling. And then this statement here worksheets my worksheet does, so that's going to generate an error. So we're going to jump to the error handling part here. And we're going to test for the urn number, and it's going to be nine.

So we're going to have this message box worksheet goldmine worksheet does not exist, please create it. And notice here, why I put the mug worksheet between two pairs of double quotes because they wanted to appear between double quotes this way, this is how you can make a word appear between double quotes when you put it in a message box or put it in in a string, which should have to double quotes, you know, on its size like that. And we're going to press OK and then we're going to end the if statement and end sub. So we've tested the air because the air that's been tested or the error the first error that's been captured here is the error for the selection of my worksheet while it does not exist We actually executed this one. Okay, we can actually comment this part here. And if we run this statement again, error go to error handling, and then range a one dot value is equal to one divided by zero.

So this way, this one is going to generate an error, which is the error for division by zero. And we're going to go to the error handling label here. And when we run the if statement, the first one is going to be false, but the second one is going to be true because the error number is going to be 11. And we're going to have a message box appear you cannot divide by zero. And if and then we're going to end the procedure. So the eerr object or the array object, what it does is that it tests for the array numbers.

So this way you can generate a user friendly message, for example, that would tell the user what the array is because you're testing for its number and each error in Excel VBA. Each runtime error has a unique Error number. So this way you can test for errors and generate user friendly message boxes or take any other actions that you would like based on that. Another useful property for the error object is the URL description. So the error description property. So what that does is that it gives you the description of the error.

Okay, so the same procedure here and I've just generated a different message box here for each error, and it says error and then the pound sign or the hashtag sign and then concatenating that onto the error number and then another concatenation onto a colon and then you know, having a new line and then the ERD description. So let's run the procedures to the first part here. The first line of code here worksheets my worksheet so that this one is going to generate an error, and we're going to jump we're going to test for the error number is going to be nine so we're going to have a message box appear here. Error number nine subscript out of range. And and if so now we're going to end our procedure. And then we can actually comment that line of code here.

And then we can run it again. And the second one is going to create an error, we're going to test for it with the if statement, we're going to have this one to be true. And then we're going to have another message box here using the ERD description property here. So I'm just using the earnest description to extract a description of the area and this is just the official description of the error that would appear if you encounter the error. So I'm just here telling you that you can use the URL description here to include in your message box, and maybe you can add more description of your own or something. Okay, so the error description gives you the official description of the air.

I'll be also including an Excel VBA runtime error cheat sheet In the resources section for this lesson, and this cheat sheet includes all the VBA runtime errors, the codes and the messages that you should get so as to have that with you as a resource. Okay, so thanks for watching this video and I'll see you on the next one.