Learning Macros & VBA will take your Excel skills and career to the next level.
Watch the overview video below to learn more.
Why Learn Macros & VBA?
Learning VBA has had a tremendous impact on my career and helped put me in high demand with employers and clients. VBA is the programming language that we use to write macros and automate Excel. It allows us to really harness the power of this awesome application.
The VBA Pro Course is an online course that will teach you how to use VBA to:
- Save time with your job.
- Eliminate boring repetitive tasks.
- Take your career to the next level.
In the training, we learned about the story of our friend Andy. As his Excel skills were improving he was taking on more projects. But he didn't have time to complete all these projects manually.
This was the story of my life when I started using Excel on a daily basis in accounting and finance roles. I was doing a lot of the same tasks everyday. Updating the same report, copying data to a different spreadsheet, formatting exported data, etc.
Not only were these tasks boring, but also a waste of time!
Fortunately, Excel has an automation tool built right into it. Visual Basic for Applications (VBA) is the programming language we use to write macros and applications in Excel.
I started using VBA to write simple macros to automate quick tasks. This learning process was a lot of trial and error for me. I spent a lot of time searching the internet for solutions, and copying & pasting code.
I'll be honest, I didn't fully understand what I was doing when I started out.
Over the last 10 years I have learned a lot about VBA. I have used it to develop robust applications and add-ins. This has not only helped me save time, but also made me a valuable resource to my employers. I am able to build systems that are relied on to run the business on a daily basis.
This responsibility also gave me more freedom. I had more time to work on fun and creative projects that had a greater impact on the organization.
I was also able to go on vacation and not have to worry about teaching my co-worker that 28 step process I go through to update a report. Instead, I was able to write a macro that did it all with the push of a button.
Who Is This Course For?
I have designed The VBA Pro Course to take you from complete beginner to a VBA pro. That sounds like a tall order, and it is. However, you will learn in an easy step-by-step manner that will give you a solid understanding of the VBA language.
This course is for you if you answer YES to any of the following questions:
- Do you use Excel frequently in an accounting, finance, engineering, marketing, HR, or analyst role?
- Do you sometimes wish there was a faster way to update or format a spreadsheet?
- Are you stuck with the task of modifying a lot of files, doing the same task to each file?
- Do you want to build robust applications and add-ins to distribute to users?
- Do you want to profit from your ideas on how to make Excel better?
- Do you wish you could go on vacation on not have to worry about teaching your co-worker that 28-step process you do on Monday's, knowing they might screw it up...?
Just like Excel, there are an infinite number of uses for VBA. This course is designed to equip you with the skills to solve problems and be creative.
What Others Are
Saying About The Course
I just went through the first two modules this morning and I was impressed. I was amazed that this was only the beginning of the course. I would consider myself average with VBA. I have written several programs and add-ins but most of that has been copying code here and there.
I learned more detail this morning than I ever expected from an intro. I thought the presentation was great. The video was clear and the audio quality was excellent.
I think the VBA Pro Course is a great fit for a wide range of Excel Users. If you use Excel regularly and have to do the same tasks every month then this course will help you automate those tasks.
If you've been using Excel for a long time (like me!) then this course will help you develop Userforms, automation apps, add-ins and the ribbon bar.
Overall, a professionally developed course, excellent interface and an easy-to-listen-to instructor. As you can tell, I highly recommend the course.
What is an Online Video Course?
The VBA Pro Course is an online video course. This means you can watch the screencast videos any time you want, in the comfort of your own home or office.
- The course is is divided into 11 training modules.
- Each of these modules is comprised of 8-12 video lessons.
- Each video lesson contains a short 5-10 minute video that helps you build your knowledge and skills.
- You get 24/7 access to watch the videos from work, home, tablet, and smartphone. Videos can also be downloaded to watch offline.
In total, you are getting over 10 hours of videos that will take you from beginner to pro. The short videos also make it easy to come back and re-watch a video on a specific topic to get a refresher.
Step-by-Step Learning Keeps You On Track
Learning VBA can get overwhelming in a hurry. So I have designed this course to allow you to consume the content in bite-sized chunks.
This allows you to practice each concept and get a better understanding of what you are learning.
We start with the basics by learning the core concepts of the VBA language, and slowly progress to building robust applications and add-ins.
The short videos also make it easy to come back and re-watch a video on a specific topic to get a refresher. Plus, the course site tracks your progress to keep you organized. You will know right where you left the course next time you login.
The lessons come with companion Excel files so you can follow along with the videos and practice the techniques.
What Am I Going to Learn?
Here is a detailed list of
The 11 Traning Modules
Modules 1 & 2: Intro to Macros & VBA
Module 1 Syllabus | Videos: 10 | Total Duration: 50 min
|1. How to Create a Macro Enabled Workbook (2:58)|
|2. How to Write a Macro and Step Through The Code (4:20)|
|3. 7 Different Ways to Run a Macro (6:35)|
|4. The Excel Object Model and Referencing Objects (5:05)|
|5. How to Reference Workbooks in VBA (5:14)|
|6. How to Reference Worksheets in VBA (6:27)|
|7. How to Reference Ranges in VBA (Part 1) (5:10)|
|8. How to Reference Ranges in VBA (Part 2) (5:27)|
|9. Working with Object Properties in VBA (5:00)|
|10. Working with Object Methods in VBA (4:09)|
Module 2 Syllabus | Videos: 10 | Total Duration: 49 min
|1. Declaring Variables and Data Types (5:24)|
|2. How to Set Variables in VBA (6:30)|
|3. How to Use Variables as Parameters for Properties & Methods (5:02)|
|4. Sub Procedure vs Function in VBA (5:09)|
|5. How to Use the Macro Recorder to Get Code (4:18)|
|6. Common Ways to Copy and Paste Cells - Part 1 (4:11)|
|7. Common Ways to Copy and Paste Cells - Part 2 (2:36)|
|8. Common Ways to Copy and Paste Cells - Part 3 (7:41)|
|9. Writing If Statements in VBA - Part 1 (3:27)|
|10. Writing If Statements in VBA - Part 2 (5:18)|
Modules 1 & 2 are an intro to macros and VBA. If you're brand new to VBA then these modules will cover all the basics of the coding language and key concepts. We look at:
- How to create your first macro.
- Different ways to run macros.
- The Excel object model.
- How to reference and work with common objects like workbooks, worksheets, and ranges.
- The various ways to copy and paste with VBA, including the most efficient way.
- Variables and data types.
- And a whole lot more!
I've had people that have been coding VBA for years tell me they learned a lot from these modules, so it's not just for the beginner.
Module 3: The VB Editor & Excel for Development
Module 3 Syllabus | Videos: 5 | Total Duration: 30 min
|1. Overview of the Developer Tab in Excel (4:40)|
|2. Overview of the VB Editor (7:12)|
|3. Keyboard Shortcuts for VB Editor Part 1 (6:39)|
|4. Keyboard Shortcuts for VB Editor Part 2 (5:56)|
|5. Option Explicit - What Is It and Why You Must Use It (6:12)|
In the Module 3 you will learn how to setup Excel for development, and how to use the VB Editor. The VB Editor is the application you will use to write the code and create userforms, and this module will explain how to use all the major components.
Modules 4 & 5: VBA Coding 101 & 201
Module 4 Syllabus | Videos: 11 | Total Duration: 34 min
|1. Coding 101 - Intro to Coding in VBA (2:31)|
|2. Overview of the List Sheets Macro & Creating the File (3:06)|
|3. Writing a Macro Part 1 - Message Box (5:37)|
|4. Writing a Macro Part 2 - If Then Statement (2:07)|
|5. Writing a Macro Part 3 - For Loop (3:38)|
|6. Writing a Macro Part 4 Compile Code (1:32)|
|7. Coding Tip - Using Syntax (1:18)|
|8. Variable Scope (3:28)|
|9. Procedure Scope (2:55)|
|10. With Statements (3:06)|
|11. User Defined Functions in VBA (5:07)|
Module 5 Syllabus | Videos: 14 | Total Duration: 68 min
|1. Error Handling Part 1 (6:43)|
|2. Error Handling Part 2 (3:14)|
|3. Error Handling Part 3 (4:33)|
|4. For Next Loop for Cells and Ranges (3:45)|
|5. For Next Loop with Numbers (3:35)|
|6. For Next Loop for Collections (4:06)|
|7. Undo History (4:54)|
|8. Input Boxes (10:29)|
|9. VBA Arrays Part 1 - 1 Dimension Arrays + The Locals WIndow (3:22)|
|10. VBA Arrays Part 2 - Looping Through the Array (2:14)|
|11. VBA Arrays Part 3 - Examples of Avoiding the Excel > VBA Bottleneck (7:53)|
|12. VBA Arrays Part 4 Multidimensional Arrays (4:42)|
|13. VBA Arrays Part 5 Resize and Preserve Arrays (3:15)|
|14. Timer Function + How to Drastically Improve Performance with Arrays (5:03)|
In Modules 4 & 5 we take a deeper dive into coding with the VBA Coding 101 & Coding 201 sections. We use real world examples to learn coding techniques like:
If Statements - The foundation of programming and decision making.
Arrays - Drastically improve code performance and efficiency.
Variables - Declare and set variables to improve code readability and speed
Loops - Loop through collections of sheets, ranges, objects, & more.
Message & Input Boxes - Make your macros and applications interactive.
Error Handling - What does "On Error GoTo 0" mean?
After setting the foundation in the first half of the course, we spend the second half learning how to build applications and add-ins.
Once you understand how to write macros and automate simple processes, you will want to start tackling bigger, more complex projects. This can all be done with VBA by developing robust applications and add-ins.
Module 6: Designing Awesome Applications
Module 6 Syllabus | Videos: 2 | Total Duration: 17 min
|1. Overview of Designing Applications (9:26)|
|2. Macro Enabled vs Add-in Files (7:37)|
In Module 6 we go over principles for designing awesome applications. You will learn the difference between macro enabled files and add-ins, and how to decide which one to use for your project.
"I am really enjoying your course. I haven't learned this much VBA since I started over a year ago.
VBA is Awesome!!!"
Modules 7 & 8: Building Userforms
Module 7 Syllabus | Videos: 15 | Total Duration: 62 min
|1. Intro to Userforms (1:41)|
|2. How to Insert a Userform (3:35)|
|3. Overview of the Listbox Control (10:23)|
|4. Working With Selected Items in the Listbox (6:47)|
|5. Remove Items From a Listbox (2:51)|
|6. How to Launch (Show) a Userform (4:26)|
|7. How to Make Code Reusable - Listbox Example (4:56)|
|8. Stepping Through Userform Code (2:20)|
|9. Userform Cancel Button (2:36)|
|10. How to Populate a Combobox (4:18)|
|11. Using Constants to Reduce Coding Errors (2:04)|
|12. The Combobox Change Event and Select Statements (6:49)|
|13. Aligning Userform Controls and Buttons (1:38)|
|14. Calling Procedures with Arguments - Programming the Command Buttons (4:12)|
|15. Homework - Challenges for Programming the Userform (2:40)|
Module 8 Syllabus | Videos: 10 | Total Duration: 38 min
|1. The Google-like Search Box (2:15)|
|2. Creating a Search Box with the KeyUp Event (8:35)|
|3. Userform ShowModal Property (2:24)|
|4. Making the Userform Flow with the Tab Index (5:22)|
|5. How to Set Focus on a Control (1:30)|
|6. Userform Keyboard Shortcuts - The Accelerator Property (2:09)|
|7. Adjusting Form Properties at Run Time (3:13)|
|8. Radio Buttons (3:06)|
|9. Checkboxes (3:54)|
|10. Organizing Navigating and Cleaning Up Your Code (5:12)|
In Modules 7 & 8 you will learn how to create Userforms. Userforms allow our applications to be more interactive and professional looking. You will learn how to program the different controls in the userform like buttons, textboxes, dropdowns, and more.
I also explain how to create the Google-like search box that I use in most of my applications. Users love this feature!
Module 9: Customize the Excel Ribbon
Module 9 Syllabus | Videos: 8 | Total Duration: 38 min
|1. Intro to Customizing the Ribbon (2:38)|
|2. Ribbon XML (3:23)|
|3. Adding Buttons to the Ribbon with the Ribbon Designer (10:33)|
|4. Additional Buttons and Controls for the Ribbon (4:00)|
|5. Custom Images for the Ribbon Buttons (3:21)|
|6. The Custom UI Editor for Ribbon Customization (2:03)|
|7. Customizing the Riboon for Excel 2007 vs 2010 and Beyond (4:14)|
|8. Customizing the Right-Click Menus (8:06)|
In Module 9 I explain how to add buttons to the Excel ribbon. You will learn about some of the different tools we can use to make this process easier and develop professional looking menus. I also explain how to customize the right-click menus so you can launch your forms and macros from anywhere in Excel.
Module 10: Creating Excel Add-ins
Module 10 Syllabus | Videos: 12 | Total Duration: 51 min
|1. Creating an Add-in File (4:50)|
|2. Tips for Working with Add-in Files (6:31)|
|3. Saving Versions of Add-in Files (2:32)|
|4. The IsAddin Property (2:29)|
|5. Overview of How to Save User Settings (4:40)|
|6. Save User Settings to the Add-in File (5:25)|
|7. Save User Settings to an INI or Text File (4:33)|
|8. Save User Settings to the Windows Registry (6:41)|
|9. Different Ways to Install Add-in Files (3:12)|
|10. Distributing and Updating Add-in Files (2:44)|
|11. Windows APIs and 32-bit vs 64-bit Excel (3:18)|
|12. Password Protect VBA Project Files (4:18)|
Module 10 is all about creating add-ins. Excel add-ins allow us to use our macros and applications on any workbook we have open. You can use add-ins to automate a simple process or create a robust application. You will also learn how to save user settings and distribute your add-ins to other users.
Bonus Module: Spreadsheet Based Apps
Module 11 Syllabus | Videos: 13 | Total Duration: 63 min
|Overview of the File Manager Application (4:11)|
|1. Working with Tables in VBA - List Objects (7:21)|
|2. Looping Through Tables - List Objects (6:20)|
|3. How to Create Files from a List or Table (8:20)|
|4. Improving Performance with ScreenUpdating and DisplayAlerts (3:19)|
|5. Replace or Overwrite Files on Creation (4:08)|
|6. Add a Timer and File Count Message (3:13)|
|7. Adding Data to Files (5:25)|
|8. Flag or Enable Files in the List (2:04)|
|9. Run Actions on Existing Files (4:19)|
|10. Add a Timestamp to the File List (4:10)|
|11. The Actions Table (7:11)|
|12. Add Hyperlinks to the File List (2:41)|
In Module 11 we build a spreadsheet based application I call the File Manager. This application allows you to automate processes of creating and modifying a set of files.
You can use this for just about any process where you want run the same macros on a large number of files. It will not only save you time, but also allow you to establish systems that your organization can rely on to get things done.
We also learn how to program Excel Tables with VBA. I explain all the great benefits of using Tables and working with them in VBA.
Some Awesome *Bonuses*
Just For You!
Bonus #1: Excel Companion Files
Along with the videos you are also getting the Excel files I use throughout the course. These files make it easy to follow along with the videos.
You will be able to step through the code to learn it, and also use the code in your own projects.
Bonus #2: The Best Course Software
The course site is very easy to use. It tracks your progress for you, allowing you to come back right where you left off. This keeps you organized and helps you focus your time on learning.
You can access the course anytime, from any device. Watch the videos on any tablet or smartphone.
Bonus #3: Comments Section on Every Lesson Page
Each page in the course has a comments section. You can ask questions here and also see what other students in the community are asking. I will be here answering your questions and helping you along the way.
Bonus #4: Certificate of Achievement
You will be emailed this awesome Certificate of Achievement when you complete the course. You can automatically post it to your LinkedIn profile, share it on social media, add it to your resume, and print & frame it.
This will help you market your new skills and let employers know that you are a certified Excel Superstar!
Hi, my name is Jon Acampora and I am your instructor for this course.
I have been using Excel for over 10 years as financial analyst and systems developer. Over that time I have become passionate about learning Excel, and finding the fastest and most efficient ways to accomplish a task.
My interests with Excel cover a broad range of topics from data visualization to application development. I have developed dozens (if not hundreds) of VBA applications and add-ins.
I have been awarded the Microsoft MVP Award for my contributions to the Excel community and helping others learn.
More than anything, I really enjoy teaching you these skills and techniques to help you work efficiently and get your job done faster! I am always happy to help answer questions, and I'm here to support you on your journey to learn Excel (and impress your boss). 🙂
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
You can access the course site from your work computer, home computer, tablet, smart phone or any other device with an internet connection.
The course site remembers your progress, so you can pickup right where you left off on any device. That means you can watch a few videos at work, then continue right where you left off on your home computer.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
How long does it take to complete the course?
This depends on how much time you have to spend each day on watching the videos. I recommend watching one or two videos a day, and then practicing the techniques in your job. If you complete one module per week then it will take 8 weeks to complete the course.
Can I download the Excel files used in the course?
Yes! You will be able to download all the files I use throughout the course. This makes it easy to follow along and test the code.
Can I watch the videos on my iPad or tablet?
Yes, the course can be accessed on any tablet or smart phone, and it looks beautiful. You can watch the course on your iPad while following along with the Excel files on your computer screen.
What version of Excel do I need?
You can use any version of Excel for either Windows or Mac. I use Excel 2013/2016 for Windows in most of the videos in the course. All the functions, formulas, and techniques explained in the course can be used on either the Windows or Mac versions of Excel, from 2003 and beyond. The bonus module on Power Pivot and Power Query will only apply to Windows versions of Excel from 2010 and beyond.
How do I ask questions and get support?
Each video lecture page has a comments section at the bottom. You can use this section to ask questions and see what questions other students have. I will be there helping to answer your questions.
What payment methods do you accept?
All major credit cards including Visa, MasterCard, and American Express are accepted.
Can my employer pay for my enrollment?
Yes, you can use your company's credit card to pay for the course. A receipt will also be emailed to you that you can submit for reimbursement to your employer. Most companies are willing to invest in making their employees even more awesome! 🙂
Can I purchase multiple memberships for my employees?
Yes, there is a team package available at a discounted price. This package includes 3 memberships to the course for you and your team members. Each team member will have their own account and be able to track their progress in the course. Please contact me (firstname.lastname@example.org) if you would like to register more than 3 members.
What if I am unhappy with the course?
If you are unsatisfied with your purchase, contact me within 30 days of purchase to get a full refund. I want you to be fully satisfied and learn a lot!
Join This Awesome Group
Until I found your course my attempts to learn VBA have been disappointing.
...too many books and 'free courses' offer too much information and not enough hands-on experience for me to make sense of the material. I think you have just the right balance here.
I believe Jon's teaching style, methods, simplicity and presentation makes this course the best way for me to learn macros & VBA.
Jon doesn't get bogged down in theoretical concepts. His approach is to get you up and running creating your own macros immediately. It is quite obvious by his presentation that he knows the subject very well. The code used for this series can be easily used for your own particular situations.