Okay. Let's go ahead and start. Let's get right into programming in VBA. So, you open up a new book, bring up the Developer tab. If you don't have the Developer tab, you can go to File, Options, Customize Ribbon and makes sure that the Developer tab is selected. So, here on the Developer tab I can click on Visual Basic and it goes over to something known as the Visual Basic editor. This is where all the magic happens this is where we're going to put the code. To put code in here, you always add a module. So let's add a module. There are other times that we'll put code behind this workbook and this sheet, but all other code goes in a module that you can insert up here Insert, Module. So, this is where we put the code. Let's just type in, and if you want to work alongside with me you can pause this and bring up Excel. So, I'm just going to call this sub, and I'll explain a lot more what all this stuff means in subsequent screen casts. But I'm going to type in Sub Test and let's just type in message box, so, MsgBox and then in quotations "Hello". All right. Then I'm going to run this using this button up here. So, I'm just going to press play and we've made a message box that displays a word. All right. So, that's real basic. We can also do things like change the color of a selection. So, I've done Selection.Interior.ColorIndex. You'll learn all about what these things are. But I'm just setting that equal to seven. So, let's go back over to Excel. You can click up here or you can do alt F11 to to toggle between Excel and VBA. So, I'm just going to make a selection and let's go back, Alt+F11, and now I'm going to run that by pressing the run button. Alt+F11 to get back. You see that it changed the interior color of the selection. This seven it corresponds to this pink color. Alternatively, if I highlighted a selection here and went up here to the Home tab, and maybe made this yellow. Let's go back to our code and now what I'm going to do is I'm going to flip this around. So, let's delete this and I'm going to put the equals sign on the left-hand side. All right. Or actually, I'm just going to write MsgBox, MsgBox.Selection.Interior.Color. So, what it's going to do now is it's going to calculate or determine the color index code corresponding to yellow and it's going to output that in the message box. So, let's make sure that the yellow cells are selected, which they are, and now let's go ahead and run this. So, I'll put six. The color index for yellow is six. Just a few more things kind of some nuts and bolts of VBA. A really important thing is to comment, to put comments in your code, and you can do that with a single apostrophe. So, I can write, "This is a comment", and it's just ignored. So, a lot of times when you're programming you want to make little notes like "this next part does this", "this next line does this", and so on. So, that's a comment. I wanted to sort of show you and highlight the most important window in the Editor is the Locals window. If that's not already up, you can go up here to View, Locals. What that does is when we go through subs and we define variables and have all sorts of things going on, you can sort of see what's going on down here with each of those variables that you have defined. All right. That's about it for kind of just the nuts and bolts and getting started with VBA. Thanks for watching.