Here is an interesting question... Why do most people try to learn Excel VBA?
There may be many reasons but they all boil down to one thing. They want to create applications that will automate time consuming tasks and save hours, days or even weeks of repetitive work.
So obviously a book or course on Excel VBA will teach how to create an application like this, right? Actually no!
Most books and courses are simply reference guides. 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.
And what this means is ...
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've searched through countless websites to try and find the information you need.
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, painful and frustrating experience. Most people build their first VBA application by using Google for every single line of code.
The reason why people struggle to learn VBA is simple…
It’s not only about creating an application.
You need to know how to build it the right way!
Most people write awful code in their first application. Over time some eventually get better. But this comes after much trial, error and frustration.
And many never get better.
— 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.
The Excel VBA Handbook is 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 even if you've never written a line of VBA code in your life.
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.
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.
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.
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.
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.
If you are using data in 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 database. 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.
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.
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.
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.
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.
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:
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.
BTW, really getting a lot out of the handbook. I am only through the first application but 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..
I wished to thank you for creating the only VBA related product (and I've bought and tried quite a few) that helped me create a useful end product to meet a real business need.
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!
Just a quick note to say that the handbook is very enlightening when coming to write vba. Together with your webinars and website this is by far the best learning tool I have come across. You have certainly opened my eyes to what can be achieved.
I have almost finished all applications in the VBA handbook. There is no doubt that it was the best programing book I have read so far.
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.
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 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.
By the way, VBA Essentials was the best code learning experience I have ever experienced.
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!
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.
Start creating Applications RIGHT NOW with the package that works best for you