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. Imaging 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.
Skipping all this frustration and time wasting
Learn 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. A course that shows you how to build 10 VBA applications from start to finish. The applications would cover a wide variety of VBA applications 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...
The Excel VBA Handbook is the only available 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.
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.
Learn how to build a simple framework for any VBA application. This application reads data from a closed workbook and writes it to the current worksheet. It may sound simple but it covers techniques you will use in 90% of your applications.
Major Topics Include: Building a simple project framework, selecting a range of data, comparing text in different cells, opening workbooks, copying data between worksheets.
Building on what you did in the first application, this one takes things much further. We run through the data keeping a running total for each team. Using data like this is a very common requirement in many VBA applications. Learn how to use the Dictionary to easily maintain running totals for multiple items.
Major Topics Include: Building a report, updating totals as the application runs, sorting a worksheet range, formatting cells, writing code to handle errors.
Use Excel to send an Email with a worksheet attached. This application shows you how you can easily interact with Microsoft Outlook. If you are planning to have an email component in your application then you can pretty much copy and paste the code from here. How emails are sent does not vary much between applications.
Major Topics Include: Sending an email, adding attachments to an email, Dealing with a collection of items, adding/deleting Worksheets, creating a new workbook.
Worksheet tables are a very useful and important part of Excel. Learn how to convert your worksheet data into a beautifully formatted table. Automatically sort or filter the table based on cell entries.
Major Topics Include: Creating a worksheet table, adding/removing table columns, using worksheet events to automatically update items, using PasteSpecial to paste formats or formulas.
Charts can add a lot to your Excel projects. Learn how to maniplate them using VBA. Create a Chart of daily prices for a user selected currency. In this application you will see how to use the Windows File Dialog to allow the user to select a file and how to create your own UserForm.
Major Topics Include: Creating a custom UserForm, adding\deleting a Chart, Inserting a chart trendline, using the Windows File Dialog to allow the user to select a file.
If you are using a Excel then a database is never too far away. Being able to connect to a database can greatly enhance the potential of your application. In this project we will read data from an Access database and write it to a worksheet. Next, we will write data from a worksheet back to the datatabase.
Even though we use an Access database, this code will work for any major database including SQL Server and Oracle. The only difference is the connection string.
Major Topics Include: Connecting to a database, reading and writing between a Database table and a worksheet, deleting all records in a database table, using optional parameters in a sub or function.
If you use VBA for any length of time you will at some stage be asked to create a formatted report. Learn the two ways to do this - using code or using a template. Here we do both so you can use either in your own code.
Major Topics Include: Reading from multiple workbooks/worksheets, formatting a report, using a template to format a report, adding sparklines to cells, measuring how long a VBA application takes to run.
Pivot Tables are one of the most powerful parts of Excel. Discover how to easily build a pivot table using VBA. Turn raw book royalties data into easily readable data.
Major Topics Include: Creating/deleting a Pivot table, adding rows/columns/filters and values to a pivot table, groupings dates by week.
Reading from a text file to a worksheet and vice versa is a common task in VBA. This application reads and writes using files of both fixed and delimited types.
Major Topics Include: Opening text files,read and writing between text files and worksheets, parsing strings, padding strings. copying files.
In modern times it is very useful to read data from a web page to a spreadsheet. This application will show you how to automate this task. Reading from web pages using is much easier than you might think.
Major Topics Include: Connecting to a web page, reading through items on a web page , reading through items in a web page table, using a class module.
"Your style is unique and fantastic. You have that uncanny skill to present something in a simplified way. The applications are based on the real world example projects. This style is very effective, engaging and practical way to learn. Probably you are the only one who is teaching this way. Other authors missed this simple and brilliant idea." - Ari Jabbar
"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." - Prinsloo Potgieter
"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." - Maciej Dolinski
"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." - John Ovens
"Thanks again for the course. It’s great. I am finding it so helpful – you have managed to combine some critical training features: Constant repetition of the fundamental features that need to become ingrained, such as structure of approach. Sufficient speed of development module to module to maintain constant growth and interest. Relevance to most commercial challenges - Databases, Email, Interaction with other programs, display of result." - Malcolm Cruickshankstrong
Q. What format does the application come in?
A. 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.
Q. Can I use this code in my own projects?
A. Absolutely 100% Yes. You can use the code however you like - personal or commercial. You can alter it any way you like.
Q. What if I don't like it?
A. Then you can get a full refund within 30 days of purchase. No questions asked! Simply reply to your receipt email.
Q. What if I get stuck?
A. Not a problem, I provide full support. You can email me at paul@ExcelMacroMastery.com. I reply to all emails. If you really get stuck we can even do a skype call.
Q. Can I try a sample?
A. 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.
Q. The price is a bit high for me
A. 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.
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.
Standard version plus 10 Exclusive Video workshops
*Please note that non-business consumers in the EU are subject to VAT on these prices.