Okay guys, so now we're going to discuss the before double click event. So before the before double click event basically executes code, whenever you double click, click on a cell in the sheet that you have created the event for. So in our case, here, we've got a sheet that is called before double click OK. And we're going to see how that event works. But before doing that, I just want to ask you a question what happens when you double click on a cell. So let's try double clicking on a cell and observe what happens. So you can see here that when we double click on a cell, we enter into edit mode for that cell so you can start typing stuff in the cell.

Okay, just gonna delete that. That's what happens. That's the default action that happens when you double click on a cell, so bear that in mind. Okay, so now we're going to go to the events for the before double click, sheet here, I'm going to right click and then view code and then From this menu, I'm going to select worksheet as usual. And from this menu, I'm going to select it before double click, and then I'm going to delete this worksheet selection change event because we don't need it. Okay.

And now we can start writing some code. You can see here that there are two parameters for the before double click event. There's a target, which we all know what it is by now. It is a range object. Okay, that that refers to the cell that you're actually going to double click on. Ok. And there is the cancel.

I'm going to speak about that in a bit. Okay. So let's write an event to trigger some code when double clicking on a certain cell. Okay, so let's say we want to trigger that code. If this cell is cell f3, if we double click on cell f3, I want to trigger some code. So let's say I want to create a message box.

Okay? So I'm going to first of all put a condition here if target dot dot address I'm going to put a full sear for the rule absolute and the column so you can put a zero as well. So zero instead of false will also work. Okay? equals F three. Okay, then And let's not forget putting an end if then message box, you double click cell f3.

Okay, so we're gonna have a message box here, you double clicked cell f3. So let's check that out. So I'm going to double click on cell f3. You can see here that you get a message box, you double clicked cell f three, okay? So that's what happens and you actually enter edit mode as well. Okay, you see can see here that in addition to having the message box, we've entered the edit mode and we can write stuff in the cell.

Let's do that again. Okay. So I'm going to double click on cell f3. You can see here I got a message box and I entered edit mode for the cell. Okay. Okay, so let's go back to our code.

So when we double click the cell, we got the message box and we entered edit mode. So this is where the console comes into play. Because the console, its type it's, it's an object that its type is a Boolean. That means it can take values of true or false. Okay? The console can control whether we enter into edit mode or not.

Okay, so if you put the cancel equals true, we are not going to enter into edit mode. So let's do that. Here. If I if we put cancel equals true, and we try that again, cell f3, double click on it, we got the message box, but we didn't enter edit mode. Okay. So this is how the council works or this is why counsel exists so as to either enter into edit mode or not.

Okay, so if at any point in your code, you want to go back to the default action for double clicking on the cell, you can put cancel equals false. And we'll just put you back to the default action. Okay? It will negate the cancel equals true line. So you can see a double click, okay, and then we go to the default action. Okay.

Okay, guys. So one more thing I want to tell you as well is what happens if we put a small f here instead of a capital F, and that's probably a mistake that people would do. Thinking that it would work the same. So let's try that. Let's double click on cell f3 here and you can see our nothing happened the message box has not appeared because the event has not been triggered. Okay.

So that's a combination that people could do actually. Okay. So make sure that you put a capital letter when using the dot address property. Okay? Okay, so let's have a practical application. Actually, it's an application that I've used personally, which is, when you double click on any of these names, the name gets selected and gets put in another cell, okay?

And I've used this application on a dashboard before where you double click, there would be a list of names, you double click on them on any of them, and then he would go to that cell and this cell would be linked to charts and stuff, okay, so that it would give you stats about that name or the item or whatever, you know, so you select an item from a list by double clicking on it, okay, so we can do that. Okay, so let's say the name is in this list. Okay. And we can actually write code to select that Okay, so if so if target dot it's in column Oh, okay. So, if target column equals okay column L is the 15th. So he started column E equal 15.

And target we can actually put it between two rows, okay target dot row is greater than or equal to and target dot row is less than or equal to six dot rho is less than or equal to six. Then we could put range l three is equal to target, okay, and if so, if I click anywhere, if I double click anywhere He won't do anything. But if I double click on one of those, you can see here that it's been put in that cell here. And so l three, and you could put a council equals true if you don't want to go into edit mode because probably this, that is what you would want to do. Okay? So double click on the name that goes into that cell and maybe that cell would be linked to charge or to look at functions or whatever, on your dashboard.

Okay, so it's a way of selecting a name from a list and you could probably instead of having a certain defined boundary for four rows, okay, so maybe the number of rows is, is variable, okay, maybe your list could shrink or could expand to maybe get the last row and do it this way. Okay, so that's it, guys for the before double click event. Thank you very much for watching this video. I'll see you on the next one.