Okay guys, so let's start learning about events. So we're actually going to start with worksheet events and worksheet events are basically VBA code that gets triggered based on stuff that happened in your worksheet or to your worksheet. Okay, so for example, when you select a different cell in your worksheet when you deselect your worksheet and select another worksheet when you select your worksheet, okay, and there are other events as well, that can get VBA code triggered by Okay, so let's see how we can start writing event procedures basically. So where do we write this VBA code in order for all this magic to happen? Okay, so what do you need to do is to go to the developer tab on the ribbon, and click on Visual Basic, okay. And then in order to write VBA code that would be executed based on stuff that happened in a certain sheet or to a certain sheet, you to double click on that sheet so you can see everything Got a workbook that is called worksheet events, okay.
And they're the objects on the workbook which are theirs, they're the sheets and there's this workbook which is related to workbook events that we are going to speak about later on, okay? But what you need to do is to double click actually on the sheet that you need the events or the VBA code to execute or get executed based on stuff that happened in that worksheet. Okay. So I need to write VBA code that would get executed based on things that would happen in sheet one or two, sheet one, okay, so I'm going to double click on it here. And what I need to do as well is in this drop down menu, instead of selecting general I need to select worksheet. And you can see here that I've got some VBA code and this is actually a procedure and event procedure that gets inserted here.
Okay, so between the private sub and the end sub that gets gets inserted automatically by Excel. You actually write your code that you that you need to be executed based on stuff that would happen. Okay? And actually, what we're going to start with is the selection change event. Okay? So you can see here on this on this drop down menu, you've got the selection change, but you can choose any event that you would like.
Okay, so the selection change event, what it does is that it makes you able to execute VBA code based on selecting a different cell in your worksheet. Okay, so whenever you select a different cell, in your worksheet, it this code will be executed. Okay. So let's see how that works. Okay, so for example, here, I'm just gonna write a message box, a very simple message box. You have triggered a selection, change event.
Okay? This is a very simple message bus because I want us show you how it works. Basically, it's very simple. You have a certain cell selected at the moment, okay, select another cell and that gets triggered, select another cell, and the message box gets triggered or whatever code you write gets triggered. Okay? So it's very, it's a very simple one.
Okay, guys, so you've probably noticed and have been curious about what's written between brackets here, which is by Val target as range. And what that means is that you've got a parameter that is called target, okay? That has the object type of a range, okay? So it's, it's, it's a range object, so it has all the properties and the methods for a range object. Okay? And what the target range object refers to is that it refers to the cell that you would select, okay?
So any cell that you select, you can refer to it as target, okay? And we're going to see how we can leverage that. So for example, let's say I want to have a message Box, that would tell me, whenever I select a cell, it will tell me the name of the cell that I selected. So it tell me you selected cell A to you selected cell B three, whatever. Okay? So I'll have a message box you have selected cell and then a space here, and then I'll close the double quotes and then an ampersand, and then I'm going to put target dot address.
Okay, so, what that will do is that it will just tell me what cell I selected. Remember, remember guys that target dot address property, okay? So I've selected cell B six here, and so it tells me select a cell B six here, it tells me selected cell j five, and then cell j 11. So whenever I select a cell, it would just give me a message box telling me you have selected that cell. Okay? And you can see here that we've got the dollar signs here.
We've got everything absolutely on the on the reference so we can actually fix that by remember guys when we spoke about the inputs for the target dot address property, we can actually make the rule absolute false and the column absolute false okay? So that we would have this appear in a more from the way so you have selected cell B six for example, okay? So target refers to this cell that we have selected, okay? And you can see here that Excel tells you the type of the object Okay, which is target okay so that you can know if you know that it's type is arranged so you know that it has all the properties and the methods of a wage objects so you can deal with it accordingly. Okay, guys, so let's do something else with our event here. Maybe I would like any cell that I would select In this worksheet to turn red, okay, so I would write target dot interior dot color.
Okay, equals VB red. Okay? So this way any cell that I would select in this worksheet would turn red. Okay? How about if I want only the cells that I would select in column A to turn red? So how do we do that?
Okay, so let's delete this line of code First of all, and let's clear our red fillings here. And let's go back and then we can actually use an if statement to do that. Okay, so if target dot column equals one, then target dot interior dot color. Equals VB red. Okay? And if so then what this will do is that if the color of, I'm sorry, if the column of the target cell is equal to one, then that means that it's in column A, the color of the cell will turn red, okay?
So if I select a song column BC, whatever, it will not turn red, but if I select it in column A, it will turn red. Okay, so, this is how you can use the worksheet selection change event. Okay, you can write any code that you would like to be executed between the private sub and the end sub here. So any code that you would like just as you're writing a normal procedure would work. Okay, but it will work based on selecting another cell in your worksheet. Okay, so, that was it.
And thank you very much for watching this video. I'll see On the next one