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
- Introduction FREE PREVIEW
- 4 Useful Tips for Viewing the Course
- 7 Essential VBA Tips - Video FREE PREVIEW
- 7 Essential VBA Tips
-
2
Application 1 - Match Result Reader
- Notes on Using OneDrive
- Application 1 Source Code
- Application 1 - Reading Match Results
- Application 1 - Match Result Reader
-
3
Application 1 - Match Results Reader REMASTERED BETA
- What is this REMASTERED BETA application?
- Notes on Using OneDrive
- 2. Application 1 Introduction
- 1. Application 1 DOWNLOADS
- 3. Application 1 Overview FREE PREVIEW
- 4. Add the Click Events
- 5. Create a Manager Sub
- 6. Create a Simple Framework
- 7. Add code to the Framework
- 8. Read the settings and open the workbook
- 9. Use CurrentRegion to get the data range
- 10. Read through the rows of data
- 11. Get the Range for Output
- 12. Write the rows to the worksheet
- 13. Conclusion
- Assignment
- SURVEY ON REMASTERED BETA VERSION
- Application 1 Quiz
- Application 1 Video Workshop
-
4
Application 2 Building a Table of Results
- Application 2 Source Code
- Application 2 - Building a Table of World Cup Results
- Application 2 - Building a Table of World Cup Results
-
5
Application 3 - Sending Emails with Attachments
- Application 3 Source Code
- Application 3 - Sending Emails with Attachments
- Application 3 - Sending Emails with Attachments
-
6
Application 4 - Create a Worksheet Table of Countries
- Application 4 Source Code
- Application 4 - Creating a Worksheet Table of Countries
- Application 4 - Creating a Worksheet Table of Countries
-
7
Application 5 - Building a Historical Currency Chart
- Important Note for non-English settings
- Application 5 Source Code
- Application 5 - Building a Historical Currency Chart
- Application 5 - Building a Historical Currency Chart
-
8
Application 6 - Reading and Writing to an Access Database
- Application 6 Source Code
- Application 6 - Reading and Writing to an Access Database
- Application 6 - Reading and Writing to an Access Database
-
9
Application 7 - Building a Formatted Financial Report
- Application 7 Source Code
- Application 7 - Building a formatted Financial Report
- Application 7 - Building a Formatted Financial Report
-
10
Application 8 - Creating a Pivot Table
- Application 8 - Source Code
- Application 8 - Creating a Pivot Table
- Application 8 - Creating a Pivot Table
-
11
Application 9 - Reading and Writing to Text Files
- Application 9 Source Code
- Application 9 - Reading and Writing to Text Files
- Application 9 - Read and Write Data to Text Files
-
12
Application 10 - Reading Data from a Webpage
- IMPORTANT UPDATE ABOUT THIS APPLICATION
- Application 10 - Reading Data from a Webpage
- Application 10 Scrape Data from a Web Page
- Application 10 Source Code
Instructor
-
Paul Kelly
I have written over a million lines of code in a 20 year software development career. I have worked for the largest insurance company in the UK, was a senior software consultant for the Worlds biggest Car Rental Corporation and have worked with many other well known companies. For the last number of years, I have involved in building advanced Excel applications and teaching people how to use Excel VBA in the real world.
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
Worth Every Dime
Drew Georgopulos
Learning so much about structuring my code
Prinsloo Potgieter
Great and inspiring examples
Maciej Dolinski
I have learned more about VBA than I could have imagined
John Ovens
I didn't know ANY VBA a few weeks ago
Jonathan Barwick
Pricing options
Explain how different pricing options might be valuable to different segments of your audience.
-
$399.00
Regular price