If you are planning to build a VBA application in the near future, then I believe this will be one of the most important messages you’ll ever read! Here’s why…


Most people try to learn VBA the wrong way!

Maybe you have bought a book on VBA and tried to learn by working through it. Maybe you have taken a three day VBA course and tried to learn this way. Maybe you used Google and tried to learn from the different websites.

Despite all this, the thought of building your first VBA application still seems overwhelming.

You may have even built your first application but found it a slow and painful experience. Most people build their first VBA application by using Google to create every single line of code.

The reason why people struggle to learn VBA is simple…


No course or book teaches you how to create a VBA application!

They explain all the parts of the VBA language but they leave it up to you to figure out how to put it all together.

Imagine trying to learn to drive a car from listening to someone talking for 8 hours. Imagine trying to learn how to ride a horse from reading a book. It would be ridiculous.

Learning VBA is no different.


The only way to learn how to build VBA applications is by building VBA applications!

It’s not only about building an application. You need to know how to build it the right way. Most people write awful code in their first application. Over time they eventually learn how to create proper applications. But this comes after much trial, error and frustration.

Imagine…

— Skipping all this frustration and time wasting

— Learning VBA from someone who does it professionally

— Becoming a skilled VBA coder in a fraction of the time it takes most people

— Having access to the programming secrets and little-known techniques used by the top VBA coders.


When I first thought about a course like this, it seemed to me like a no brainer. Yet, no course like this existed.

I considered creating the course myself. At first I was reluctant. It would take considerable time and effort to create full applications and to provide a step-by-step guide for each one.

Based on the number of comments and queries from readers of my blog it was apparent that most people struggle to create VBA applications. Time and time again I was seeing mistakes and frustrations that could easily be avoided if the user has access to the right information.

I floated the idea to people on my email list. It would be a course that shows you how to build 10 VBA applications from start to finish. The applications would cover a wide variety of VBA topics so the user could see how the same principles can be applied to any application.

The feedback was overwhelmingly positive. People were literally begging me to create it. Twelve people paid up front from me to go ahead and create the package.

And this was how the Excel VBA Handbook came to exist…

What is the Excel VBA Handbook Course?

The Excel VBA Handbook is the only available Excel VBA course that teaches you how to build VBA applications from scratch. It will teach you to build any VBA application by taking you step-by-step through the creation of ten full VBA applications.

Unlike your typical VBA course, it will teach you practical and useful VBA code that you can use immediately. It will show you proven principles and little-known techniques that professionals developers use to create their own applications. It provides explanations in clear English that anyone can follow.

It will ultimately show you how to build any VBA Application in a fraction of the time you thought possible.

The Excel VBA Handbook will help you to…

  • Build VBA applications in 10% of the time it normally takes you.

  • Produce Bulletproof VBA code for any application.

  • Create applications that are suitable for use in a real-world business environment.

  • Reduce the time you spend fixing errors by up to 90%.

  • Learn concrete and demonstratable skills that will enhance your career opportunities.

  • Learn techniques you can apply immediately to any VBA application.

  • Amaze your colleagues as they wonder "How did you become such a genius at VBA?"

This is the only VBA resource that…

  • Walks you through the creation of VBA applications in a easy to follow step-by-step manner.

  • Gives you a simple framework with which you can build any application in VBA.

  • Teaches you how to write easy-to-read professional quality code.

  • Shows you how to design, plan and build a full VBA Application.

  • Provides thousands of lines of ready-to-use code.

I’ve spent nearly 5 years developing, testing and optimizing the most complete, proven and easy-to-use system for building VBA applications

— PAUL KELLY

Course curriculum

    1. Introduction

      FREE PREVIEW

    2. 4 Useful Tips for Viewing the Course

    3. 7 Essential VBA Tips - Video

      FREE PREVIEW

    4. 7 Essential VBA Tips

    1. Notes on Using OneDrive

    2. Application 1 Source Code

    3. Application 1 - Reading Match Results

    4. Application 1 - Match Result Reader

    1. What is this REMASTERED BETA application?

    2. Notes on Using OneDrive

    3. 2. Application 1 Introduction

    4. 1. Application 1 DOWNLOADS

    5. 3. Application 1 Overview

      FREE PREVIEW

    6. 4. Add the Click Events

    7. 5. Create a Manager Sub

    8. 6. Create a Simple Framework

    9. 7. Add code to the Framework

    10. 8. Read the settings and open the workbook

    11. 9. Use CurrentRegion to get the data range

    12. 10. Read through the rows of data

    13. 11. Get the Range for Output

    14. 12. Write the rows to the worksheet

    15. 13. Conclusion

    16. Assignment

    17. SURVEY ON REMASTERED BETA VERSION

    18. Application 1 Quiz

    19. Application 1 Video Workshop

    1. Application 2 Source Code

    2. Application 2 - Building a Table of World Cup Results

    3. Application 2 - Building a Table of World Cup Results

    1. Application 3 Source Code

    2. Application 3 - Sending Emails with Attachments

    3. Application 3 - Sending Emails with Attachments

    1. Application 4 Source Code

    2. Application 4 - Creating a Worksheet Table of Countries

    3. Application 4 - Creating a Worksheet Table of Countries

About this course

  • $399.00
  • 56 lessons
  • 12 hours of video content

Instructor

Paul Kelly

Paul Kelly, a Microsoft MVP, cuts through the jargon to teach practical Excel VBA for real-world use. With a career spanning 30 years and a degree in Software Engineering, Paul has honed his skills in sectors like finance and automotive, earning a reputation among major firms. He's the force behind Excel Macro Mastery, a website and YouTube channel with a peak of a million yearly visitors and 80,000 subscribers, respectively. Paul excels in demystifying VBA with easy-to-grasp, actionable lessons backed by his extensive experience. His focus? Giving students the tools they need with code examples ready for real-life application.

Frequently Asked Questions

  • What format does the application come in?

    The guides are in PDF format. There are also Excel workbooks with code and data. The Premium version includes a video workshop for every application.

  • Can I try a sample?

    You can try it all for 30 days. If you're not happy with it I will give you a full refund - no questions asked.

  • The price is a bit high for me

    One day of training in VBA starts at around $400. It won't teach you how to create VBA applications, give you thousands of lines of free code or support you if you get stuck.

  • Can I use this code in my own projects?

    Absolutely 100% Yes. You can use the code however you like - personal or commercial. You can alter it any way you like.

  • What if I don't like it?

    Then you can get a full refund within 30 days of purchase. No questions asked! Simply reply to your receipt email.

  • What if I get stuck?

    Not a problem, I provide full support. You can add a comment or send a message to me from the course.

How do I know if this is right for me?

If you can answer yes to one or more of the points below, then I’d say you’re perfectly qualified to jump into VBA Applications and get the most out of it:

  • You are going to build a real world application in the near future and you’re feeling overwhelmed.

  • You’ve spent a significant amount of time trying to learn VBA but still feel disheartened when trying to create an application.

  • Your new position requires creating a VBA application and you feel you’re lacking the knowledge and skills.

  • You enjoy VBA but find creating applications a slow and frustrating experience.

  • You want to master VBA in the shortest time and most efficient way.

  • You would like to create a VBA application for your own work but don’t know where to start.

  • You have created applications in the past but you feel there is a lot of room for improvement.

  • You want to improve your career opportunities by gaining a greater understand of VBA than any of your peers.

Who this is not for

If you’re not willing to put in the time and effort then the VBA Handbook is not for you.  Just like any worthwhile skill, VBA requires work and practise. You can read the books and watch the videos all day but you have to be willing to put the effort in and go ahead and build the applications for yourself. Remember the only way to learn how to build VBA applications is by building VBA applications.

What Customers Have Said

Love your methodology

Ingelise Morales

I have just started going through your Excel VBA Handbook, which is fantastic and will indeed help me greatly. I already love your methodology … simple and organised – excellent!

Worth Every Dime

Drew Georgopulos

Your approach of stubbing an application outline, implementing just what you need, then going back to refine details is perfect, holding a lantern up for one to find their way, AND leaning additional features & gotchas about Ranges & references as you go. Brilliant! Your product was worth every dime

Learning so much about structuring my code

Prinsloo Potgieter

Secondly, just a word of thanks for an excellent and informative VBA Handbook. I am learning so much about structuring my code and making it easy to follow. And man that Dictionary part! Not to speak about the “FilterorSort” executing whenever one of the selected cells are changed! And and and ...! Fantastic stuff – Thank you.

Great and inspiring examples

Maciej Dolinski

Thank you for the VBA Handbook. It is one of the best courses I have taken! It is very practical and provides great and inspiring examples. The course is not VBA course, but VBA programming course. I love your practical approach. There are many courses that teach the language, but not so many courses teach programming.

I have learned more about VBA than I could have imagined

John Ovens

I first encountered Paul on Udemy and wish I had come across him many years earlier. I have learned more about VBA than I could have imagined. After completing the Udemy course I purchased his VBA Handbook and completed the exercises. Thanks heaps Paul.

I didn't know ANY VBA a few weeks ago

Jonathan Barwick

I have used the info to get a large chunk of a work project done, and I didn't know ANY VBA a few weeks ago. Pricey, but well worth it.

Pricing options

Explain how different pricing options might be valuable to different segments of your audience.