So, let's go ahead and get started with UserForms. You start with the editor, the Visual Basic Editor. Instead of inserting a module, you insert a UserForm, and it brings up kind of this generic form. And this is where then it's sort of like this canvas or an area that you can put in the various things. Down here in this tool box, this is where you find the various elements. So if I just wanted to label, I can drag that up here, and I can rename that something. So I'll just rename this A input. We can also add in text boxes. So I can bring in one of those. Everything in VBA in UserForms has a name and if you go down here to the properties window, this is really important. If that's not showing, you can go up here to view and click on properties window but everything has a name, it's an object, this is object-oriented. So our A input, it's actually that object is named Label1, our first text box is named TextBox1. You can change these different things and the text box, we're going to be doing in this example is going to be having an A input and a B input and then we're going to select either if we want to multiply those numbers or divide them and then we're going to have an output. So, I'm going to name this guy something generic like A input. It doesn't matter what the labels are named because we don't really use them typically. So I'm going to go ahead and copy and paste those and I'm going to reformat this to name this B input and I'm going to rename this B input. So this object here is a text box that's named B input. This is named a A input and that's important. It's important that you remember what those are because we're going to write code that uses those variables. Next, I'm going to just copy this and this is going to be our output. So, I'm just going to name this Output. So again, that's another object, that's going to be a variable name in our calculations. I'm also going to copy and put another label over here. So this is going to be named Output. If you want to change the caption up here for the UserForm, you can always go here. Well, right now, this is named UserForm1 so that's the name of it. But if you want to change the caption, you could put it here. So you could say something like Calculator and that changes the caption. You can also change the font of all these things. If you click on this and go to font, you can mouse around with changing the different options for the formatting. So everything has properties and you can change them down here. If you wanted to make this centered, then you can go down here and you can do text align, you can change this to align center. There's all sorts of options. I'm not going to waste time in this screencast and going over all those but those are types of things that you'll learn as you gain more experience with UserForms. I'm going to go ahead and add in two buttons. There's a command button here. It looks a little different here than on the older versions of VBA, the newer version has quite a few changes as far as the formatting goes. But if you have older versions, it's just fine. You have to find the right icons here. So that's I'm going to put a command button there and a command button here. I'm going to change the labels on here. So I've named this one RESET and this one CALCULATE. So, I'm going to kind of pull these down a little bit. There's one more thing that we're going to do and let me just format this, bring this up a tiny bit. I'm going to add in something known as a frame, and I'll explain what a frame is here in a minute, but I'm going to add a frame in there and I'm just going to delete the caption here, so we just have a frame and I'm going to add two option buttons, also known as radio buttons. Now, option buttons, if they're placed inside of a frame, then only one of them can be selected at any one time. So, I've just changed the name to Multiply, Divide. I'm not going to spend too much time changing around the format. You really have to spend a lot of time kind of formatting everything. But anyway, if I just press the run here, it opens up what this calculator looks like so far, and I can put in the different elements here. And we see here that in there we can select one of these. And by selecting one, it deselects the other. That's what a frame does. Right now though, it doesn't do anything. So I'm going to go and close this and we're going to work on putting code behind the Reset button and the Calculate button. And what I'm going to do first is we need a default because at the beginning, neither of these is selected so I'm just going to click on Multiply which, it has a name here. I'm going to rename that multiply, lowercase. So that's the name is called multiply. I'm going to name this divide and I'm going to click back and multiply and make sure that it's highlighted and I'm going to put this to the default. Down here at the very bottom, it says Value. So I'm going to change that to True. That'll make it by default, True. So now, if I press the run, you see that by default it's true then I can deselect it that way. So whenever we run this, we're automatically going to have that toggled to begin with. So let's work with writing the code behind everything but just kind of remember what everything is. We have A input, B input, output. Those are all the names that we're going to use in the code. Then we have, this is named multiply, this is named divide, and then we have, I'm going to call this reset button, and I'm going to name this calculate button. And actually, there's one more button that I usually put on here. I like to have a quit button. So I'm going to name this QUIT. I'm going to name that button quit button and again, I'm not going to worry about the formatting for now. But afterward, you can spend some time cleaning this up. Let's first code the quit button. You put the code for what happens whenever the button is clicked. I call it behind the button. So I'm going to double click on the quit button and you see it brings up this private's up. This is where you're going to put the code for what happens when that quick button is clicked. Now when the quit button is clicked, there's two things we can do. One way to do this is to hide the UserForm. So, I'm going to kind of leave that as the default for now. The second option is you can do Unload UserForm1. That's another way to quit. The difference is that Hide will keep everything in the input fields that the user has selected. So if you show it again, those values will still be there. Unload erases everything and then shuts it down. Let's go ahead and code the reset button. So I'm going to click there. This is what happens when the reset button is clicked. What we want to happen is everything erased but then we want the UserForm to be shown again. To erase everything, we can use Unload UserForm1 but that actually shuts the UserForm down. To show it again, we can use UserForm1.Show. So this is how you can reset a UserForm. And I just wanted to point out that we're using UserForm1 here because the name of this calculator, we're not using the caption name, we're using the name which is shown here. You can change that name if you'd like. So we've got the reset button we're going to unload and then we're going to show the UserForm. Now the last button we need to code is this calculate button and the calculate button is going to depend upon if we have multiply selected, and our radio buttons are booleans, so they're either true or false, or if we have divide selected. So I'm going to go ahead and put the code behind calculate. And I've set this up as a two-way if-then. If multiply is selected, that's the radio button or the option button for multiply, then this is what's going to happen. The output is going to be A input times B input. Otherwise, we're going to take A input divided by B input. We're going to do a few more things here. Usually, you don't run the UserForm from the editor. Instead, what you do is you create a module that's going to open up the UserForm. So, I'm going to insert a typical module, I'd like to call it something like run form, and it simply is just going to show the UserForm. So, that's how then, if I run this, I'm going to press F5, it opens up that form. What I also like to do is add an event handler and that is in this workbook. So, I'm going to click Workbook. The default is Workbook_Open, and I can just type the name of the sub routine. So, when the workbook is open, we're just going to run the run form sub, the run form sub shows UserForm1 and we'll open up the UserForm1. So I like to put an event handler so when the workbook opens, we open up the form automatically. One more thing, sorry. The last thing I like to do is to insert a button so I'm going to insert a button here and we're going to assign that to our run form macro which opens up the UserForm. So now, when I run, the run button runs the run form sub routine that opens up and shows UserForm1. So now, I can put in my inputs like 10 and five, and let's calculate. We get 50. We can reset. So that shuts down but then opens it back up. I can do 10 and two, and I can do divide, and we calculate that and then we can quit. So this sort of shows you an example of a real simple UserForm. In subsequent screencast, we're going to be going over some more advanced UserForms and I'm going to provide the templates on the website so you guys don't have to spend the time making all the UserForms. Thanks for watching.
