Developing for Excel with VBA

You’re an Excel power user. You can filter data and write formulas with the best of them. But can you use VBA? If not, you’re not making the most of Excel! Watch this course and learn how to build custom user applications in Microsoft Excel.
Course info
Rating
(37)
Level
Advanced
Updated
Oct 29, 2019
Duration
2h 38m
Table of contents
Course Overview
Introducing VBA
Connecting Excel to a Database
Building a VBA Application in Excel
Enhancing and Debugging a VBA Application
Sending Data to Different Workbooks with VBA
Description
Course info
Rating
(37)
Level
Advanced
Updated
Oct 29, 2019
Duration
2h 38m
Description

Microsoft Excel. It’s one of the most popular and used applications in the world, especially in business. Most people can use it to manage data and run simple calculations. But did you know Excel has a programming language built into it, and it can do so much more? No? Then this is the course for you! You will learn all about Visual Basic for Applications (VBA), the programming language built directly into Excel. You’ll find out what VBA is and how it became part of the Microsoft Office suite. More importantly, you’ll discover how VBA can be used to create user applications, querying a database to perform searches. You’ll also see how user interfaces can be built using Excel worksheets, and how buttons can be used to call your code. Whilst all this is going on, you’ll learn how to structure and debug your code. Once you’ve built your first application, you’ll discover how to manipulate other Excel workbooks, inserting values and saving the file as a PDF! By the time this course is through, you’ll have an excellent knowledge of Excel VBA programming, and will have all the skills you need to start creating your own custom spreadsheet applications.

About the author
About the author

Mike loves to mess around with data and programming problems, the bigger the better. He’s worked with a variety of companies, helping to build and improve systems of all shapes and sizes.

More from the author
Loading Data with SSIS
Beginner
2h 59m
Sep 2, 2020
Building Your First VBA Module
Advanced
1h 57m
Nov 6, 2019
More courses by Mike McQuillan
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hey folks, welcome to Pluralsight. My name is Mike McQuillan, and this course is all about Developing for Excel with VBA. Excel is just a boring, old spreadsheet application when it's being used for maintaining to-do lists and accountancy-type stuff anyway. But what if you could make Excel dynamic, exciting, and, dare I say it, fun? Welcome to the world of Excel programming with Visual Basic for Applications or VBA for the cool kids in the know. With VBA, you can create all sorts of fabulous, little mini applications in Excel using lots of programming trickery. And this is the course that will show you how to do it. You'll find out what VBA is and how it became part of Excel before learning all about programming in VBA. You don't need to know a lot about programming to start with as you'll learn how to record and capture macros, which you can edit for your own purposes. The course shows how Excel can be hooked up directly to an SQL Server database. Now it's no good linking up to a database just for the sake of it, which is why we look at how to build up a nice user interface. A user interface is pretty pointless without some top-quality code behind it, which is why we go through absolutely tons of VBA codes to make the interface do something useful. From adding references to creating modules, you'll see it all. You'll find out about functions and subs, validating user input, and how to handle issues caused by core Excel functionality. You'll even see how to manipulate multiple workbooks and generate PDF files. Once you've made your way through that little lot, you'll be well on the way to creating your own super cool Excel applications. Hope to see you at the course. Thanks for watching.