Welcome to the spice aisle tutorial. In this video, we're going to cover creating user forms in Excel VBA. The video is all about designing your own dialogues to allow users to interact with your workbooks in a nice, efficient way. So, I'll talk about how you can add a form to a VBA project and then how you can add controls to the form to allow the users to interact with it. I will mention a few of the useful drawing tools to help you layout your controls neatly, including aligning and distributing them. Then, we'll talk about how you can actually make the form interactive. I'll discuss how to work with the properties of a form and the controls on it. I'll also explain how you can add code to the form events to respond to what users do inside the form. In the final part of the video, we'll talk about validating forms to make sure that users always enter sensible values. It's quite a long video with quite a lot to do. Let's get started designing a user form in VBA. A user form in VBA provides a really convenient way for your users to interact with a workbook. So in this video, we're going to design a simple form that allows the user to add a new film to the end of our list. The form is going to end up looking something like this one. It's fairly simple, but it's also nice and intuitive for the user to interact with. We've got clearly labeled controls, so it's easy for them to know where to input information. They can type in a film name into the film name field, and then they'll see that they need to select a date. They can do that from a nice date/time picker control, so...
Award-winning PDF software
Video instructions and help with filling out and completing Form 2220 User
