In this screencast, I'm going to teach you about event handlers. So, I've opened up a new workbook here. I'm going to go into the developer tab. Now instead of inserting a module where I put the codes or generally we've been creating a module, but I'm going to show you how you can put code behind this sheet. So sheet one or this workbook. Typically, when you're making subroutines you want to put your code in a module. But for event handlers, these things know as the event handlers, you're going to want to put your code behind either this workbook or whatever sheet. So I'm just going to go into sheet one and it opens up sort of this module that's similar to when you insert a normal module. And up here from the drop-down menu, I'm going to select worksheet. Now, there are all sorts of different options over here. These are called event handlers. So before you right click, you can do different things. So, let me click on that and I'm going to put an example here. This is a Private Sub. So whenever you right-click, this is what's going to happen before you activate what's normally activated when you right-click. So let me just put in an example here. So I've just put a message box you just right-clicked. So if I go to sheet one and I right-click, then it's going to bring up that message box and then it brings up the normal right-click menu. So you wouldn't ordinarily have a reason to do this, but if you for some reason you want it to have an event happen. So this is an event when you right-click, then you can put the code in there in this Private Sub. The default, one of the most common is changing a selection. That's why when you bring up the worksheet here, selection pops up because that's kind of the most popular. But I can also put something in here. For example, ActiveCell equals ActiveCell plus one. Now when I go to worksheet one and by the way, if I had a worksheet two here, if I included worksheet two, these event handlers don't happen to sheet two because I've written it in the code behind sheet one. So now whenever I change a selection, I'm going to add one to the active cell. And this is quite annoying. There's no reason you would do this ordinarily. But this is known as an event handler. So let's see what happens if you add an event handler to this workbook. So am going to double-click on this workbook from the drop-down menu, I'm going to bring up workbook. The most common is an event handler when the workbook is opened and I'll just put in something like this message box "welcome to Excel 2016. Did you remember to turn off the stove this morning?" I'm going to save this file and I'm going to close it because we can't really see the effect of this Workbook Open event handler until we open it. I save this onto my desktop. So now I'm just going to double-click event handler example, and when we open this up, it pops up with this message; "Welcome to excel 2016. Did you remember to turn off the stove this morning?" I can also put something like this applicationspeech.speak. Not every version of VBA, I think only the newer ones have this, but I can put in "Welcome. Have a nice day, Charlie." And when I save this and reopen,. "Welcome. Have a nice day, Charlie.". It gives me a nice little welcome message. And just one more example, I could put a message box "Would you like to know the time and date?" That's going to be Yes or No. If answer equals six, then we can message box now. And when I save this and close it and reopen, I get the following. And I can then select Yes and it'll output the time and the date. Event handlers are not tremendously useful, but they are really useful when you're providing a spreadsheet or a macro-enabled file to a client or a co-worker and you want to have things professionally presented. We're going to be making user forms in the rest of this module, an incoming screencasts and what we want to happen is when the workbook is opened, we want the user form to automatically open. So, I introduced event handlers here because they're nice to use when we start talking about user forms.