Visual Basic for Applications and Excel. What a combination! They can do lots of magical things, but just writing VBA code isn’t enough; you need to write efficient code. VBA modules help you do that, and this course will teach you how to use them!
There are lots of Excel VBA developers out there, and they’re all creating great Excel applications, but are they all structuring their code correctly? If you want to know about good code structure and how to make your code more reusable, this is the course to watch! In this course, Building Your First VBA Module, you'll use a pre-built application to learn about the three types of module VBA supports – Standard, Object, and Class. First, you’ll learn about the differences between them and when you might use each type of module. Next, the course takes a deep dive into class modules, outlining how to design and build a class module, how to use module events, and how to expose properties with getters, setters, and letters. You’ll also see how to test your code and how to extend your class module’s capabilities with external references. Finally, once you know how to build class modules, the course shows you how to use them, integrating the class module with a user form to build a completely custom user interface. You’ll find out how to add controls to user forms, as well as how to manipulate them via VBA. When you're finished with this course, you'll be able to take your VBA skills to the next level!
Software required: Microsoft Excel, SQL Server Express, SQL Server Management Studio.
Course Overview [Autogenerated] hello. They welcome to plural sites. My name is Mike McQuillan on this course is all about building your face. Phoebe. A module maybe. You know it's wrong. Phoebe es and user fairly regularly for your wondering. If you could improve the way you use it. Guess what you can. This is just because you are looking for as it will teach you all about modules, something only the hottest BB eight developers know about. You'll learn what modules are on, why they are used. There are three different types of module on the course, explains all of them. You've probably used standards on object modules before, but if you have just given the surface of BB A, there's a strong chance you haven't utilized class modules, which is fortunate as we discuss them in depth. During this course, you'll see how to build a class module from start to finish, Beginning with the design a moving onto in depth developments, you'll find out all about properties, public and private methods, events and even testing your codes exhausted. Yes, well, keep up because there's more. That cost includes by showing how to use your shiny new class model in Excel application. Integrating gets with a user to find form, you'll discover how to create a form on how to act controls on co two forms. By the time this course is finished, you'll wonder how you ever developed a deviate without using modules. You'll have all the skills you need to create your own mega cool modules. I can't wait to see you at the course. Thanks for watching.