May 2023
Beginner to intermediate
2h 25m
English
Overview
VBA (visual basic for application) is a language used for programming tasks and actions in Excel, and for developing additional functions in Excel worksheets that are customized to your work needs.
If you want to learn how to program VBA for your business or yourself, then this course is for you. As a beginner course, it starts with the basics—understanding what VBA is and what it does. Next you’ll record your first macro, and eventually you will know enough to create your own functional VBA modules.
By the end of the course, you’ll be creating custom Excel functions and making your user forms so other users can interact with them and input their data. You'll also be able to troubleshoot and debug your code, making it fast and efficient.
Once you learn VBA, you’ll know it forever, and eventually you can program it to do all your work.
Distributed by Manning Publications
This course was created independently by Meta Brains and is distributed by Manning through our exclusive liveVideo platform.
About the Technology
About the Video
What's Inside
- Learn what VBA is and what it does
- Install VBA and record macros
- How to create functional VBA modules
- Set up user forms so other users can interact with them
- Use the Excel VBA program aids for doing complex and tedious office tasks
- Create an Excel Macro using a command button
- Troubleshoot and debug your custom Excel functions
About the Reader
No preliminary knowledge about VBA required
About the Author
Meta Brains is a professional training brand developed by a team of software developers and finance professionals who have a passion for coding, finance, and Excel. They bring together both professional and educational experiences to create world-class training programs accessible to everyone. Currently, they're focused on the next great revolution in computing: The Metaverse. Their ultimate objective is to train the next generation of talent so we can code and build the metaverse together!
Quotes
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.