Okay, guys, so now we're gonna speak about the code window and the code window or the modules are basically containers for your macros. And this is where you're going to write code. This is where you're going to write VBA code. And this is where most of the action actually is going to happen. Now, you can see here that I've got a module here that is created that is called module one. And module one has been created because I recorded some macros here on this workbook, the absolute macro and the relative macro.

But actually, even if you don't record macros on your workbook, a module is already created in Excel, which is for example, the sheet module here. This is a module that is already created in Excel and you can start using it so I can write a Sub procedure called testing code for example, and then I can just write any coach range D one equals one for example. This is going to put the value of one in cell D one. So if I run that, it would still work. Okay? However, normally you do not use the worksheet module or the workbook module to write normal macros, you'd normally use them to write event procedures.

Okay? So I'm just gonna delete that because normally you would write normal macros in modules, you'd create a module, either you created or Excel would created and then you would write the macro that way. Okay, so let's go back to our code window here. And as you can see here, at the top, we've got two menus here to drop down menus, we've got the object drop down, and we've got the procedure drop down, and the object drop down allows you to select different objects, okay, and we will see that in the future, especially when we deal with events and this procedure drop down allows you to use a story To procedure for that particular object. So for example, if you select a worksheet, you could use the procedure for activating the worksheet for example, which is going to be the event whatever code you're going to fire whenever that particular sheet is activated, and we will see that in the future.

Now Currently, the object drop down has only general in it, because we're in a normal module, but when we're working in events, you're going to see workbook or worksheet and in this procedure drop down you're gonna see your macros your different macros. Okay, so I've got here the opposite of macro and the relative macro. Okay, so right now in this module, we've got two procedures, we've got the absolute macro procedure and we've got the relative macro procedure. And as you can see here, I can see both procedures in the module. If we look at the bottom here, we will see that we've got two buttons. We've got the full module View button and the procedure View button and these buttons enable us to either have a view viewing all the procedures in the module or just a single procedure.

So actually, if we switch to the procedure view while we are in the absolute macro, if you click on that you can see here that we are now in a view that shows us just a single procedure. And this is useful if you've got a lot of procedures in your module and you would like to focus on just one procedure in order to avoid writing code in the incorrect procedure. So if you go back to the full module view, you'll actually see all the procedures in the module. If we click inside the relative macro and go to the procedure view, you can see here we are now focused in the relative macro procedure. Okay, so these two buttons enable us to toggle between either a full module view or just a focused view on a single procedure. Okay, so now you see this bar here on the left.

This is called the margin indicator bar. And it's going to give us some visual cues or visual indicators when we're doing error handling and debugging for our code, and we'll see how to do error handling and debugging in the future. So thanks for watching guys. I'll see you on the next video.