Why Learn Macros & VBA?
This is definitely a powerful skill to have in the office. When I entered the workforce, I quickly learned that I was the only person in the entire company that knew VBA, My former classmates confirmed that they were in similar situations, high demand for Excel skills, and especially VBA, with few people that knew it. In today’s competitive workplace environment, knowing the “in’s and out’s” of Excel isn’t enough to solve every problem out there.
Perhaps you find yourself doing the same tedious & frustrating commands that are necessary but take a ton of time to complete. Maybe you are a power user in Excel, and your boss has noticed that, and they are giving you more spreadsheet tasks to complete, which is increasing your workload without really moving you forward in the company. I don’t think that anybody likes doing boring, repetitive tasks, no matter how necessary they are.
Enter Learn VBA for Excel
Learn VBA for Excel will teach you in a step-by-step system that will take you from complete beginner to being able to write macros that will:
- Automate any repetitive task.
- Save time
- Stand out from the crowd in the workplace
VBA can reduce the time needed for some tasks from hours to literally, seconds. Wouldn’t that be nice to simply press a button and automate your daily, weekly or monthly tasks?
Doesn’t that sound nice?? Let me tell you, IT IS! I have been able to do that for years, which has saved me tons of time and avoided frustration while at the same time making me stand out to my boss because I am saving the company time and money.
WHO AM I
My name is Steve Horman and I am just a normal guy who loves Excel! I have been learning it for more than 10 years. I first heard about VBA for Excel when I was in my college accounting classes. I had a class where we learned this invaluable skill. My professor taught me the basics to get started and I had to learn the rest; which hasn’t been an easy task.
While working on my masters, as a TA I automated grading assignments to save me hours of tedious grading. I have also developed applications to help pick stocks, optimize building sequences in Clash of Clans and now as an employee, I help many departments automate or optimize daily processes they have.
I started learning VBA because my professor said I should continue to develop this skill. What I didn’t anticipate was the giant void it filled in the workplace. From the day I was hired to now years later, I have used VBA to save time, money and frustration!
Why did I create Learn VBA for Excel?
It definitely wasn’t easy teaching myself to write macros. I wasted many hours google searching for answers to specific problems I had and wasn’t able to always to find the answer. I asked my college classmates what they did and the most common reply was, “Struggle.” I found it wasn’t an isolated problem that only I dealt with.
Additionally, at one of the companies I worked for, I quickly learned that I was the only person in the entire company, that knew VBA and that included the IT department (2,000+ employees). My former classmates confirmed that they were all in similar situations, high demand for Excel skills and especially VBA, with few people that knew it.
Seeing this true need, I created a step-by-step system to help people learn this extremely valuable skill.
What is Learn VBA for Excel?
Learn VBA for Excel is my premium 6 module online course to take Excel users from beginners in VBA to experts. It covers everything you need to get a solid foundation so you can write your own macros with confidence.
There is no guessing what a piece of code does. Learn VBA for Excel has dozens of videos that will walk you step-by-step through everything to get you started.
What's Included in Learn VBA for Excel?
Module 1: Introduction to the VBA Environment
This module starts you out with the foundation you will need for the rest of the course. You write your first macro and learn what menu options you have.
Module 2: Statements & Operators
Here you will learn about loops and conditional statements. This will give your code the ability to make decisions! We start with the if statement and then go through the Do and For loops.
Module 3: Formatting with VBA
This module shows you MANY different formatting options you have with VBA. Essentially you will learn how to use the buttons on the Home tab in regular Excel, but using VBA to do it.
Module 4: Forms
Here you will learn everything to do with forms. I show you the Message& Input Boxes and you can customize them. I also show you a special VBA Inputbox that can replicate loops without using one! Then I break down the highly customizable UserForm. I show you all the different aspects of the form and how each works.
Module 5: Automation & Function
In this module, I show you the many different ways to call a macro automatically, whether that’s pushing a button, or adding one to the ribbon, or using events. Then you will learn how to write your own custom function that could work either in the VBA environment or in regular Excel. Then I walk you through how to leverage the macro recorder. And then we will wrap it up with showing how to create your own personal macro workbook
Module 6: Other Useful Tips
Here you will learn a couple of major things. I walk you through what objects are and how they can save you time and reduce potential errors. Creating datasheets, how to manipulate files, and variable scope are also covered here. Then I walk you through the 4 different types of errors and how to prevent/catch them. Lastly, I show you the single best line of code to handle an error.
Also Recieve 5 Fantastic BONUSES!
Bonus 1: Companion Files & Homework
This bonus has two parts. The first is all of the companion workbooks that you will see me work on during the course are yours to download! Additionally, there is homework to accompany the lessons so you can have a practical example for you to practice on.
Bonuses 2 – 4 (Cheatsheets)
All these cheatsheets are in a searchable format so you can ctrl + F and search for the topic that you want! This is way faster and more accurate than Google searching for an untold number of hours and attempts.
Bonus 2: Formatting Cheatsheet
All the formatting code syntax is here on this sheet. I cover MANY different types of formatting and list how to use each member. Fonts, Custom Cell Formatting, Borders, & Indention Levels are some of the topics covered here.
Bonus 3: Statements & Operators Cheatsheet
The best statements and operators are each broken down and shown how they work with descriptions and examples. It also explains both the logical and mathematical operators.
Bonus 4: Functions, Members & More Cheatsheet
This cheatsheet is unbelievably useful. It covers many different topics that range from listing all major VBA functions to the most used keyboard shortcuts and everything in between. Creating tables, freezing panes, workbook/worksheet members are just a few of the things listed out on this value-packed document.are some of the topics covered here.
Bonus 5: Forms Checklist
This is a 23 point checklist that walks you through exactly how to “finish” a form. By completing each section and point ensures that your forms turn out looking professional and bug-free.
On the Bonuses...
These bonuses are astounding! They are the accumulation of years of learning. These are my personal cheatsheets and checklist that I use when I am coding. They make it so I don’t have to waste time looking for the syntax of something.
IS THIS FOR ME?
This course is designed to allow complete beginners of VBA to become experts. Its a step-by-step system to allow anyone to gain a solid foundation first and then learn more advanced concepts and materials. That being said, this course isn’t for everyone. It is for you if you answer YES to any of the following questions:
- Do you use Excel frequently in an accounting, analyst, finance, engineering, marketing role?
- Do you wish you could go on vacation and not worry about that 23 step process that you had to teach your coworker?
- Do you want to elevate yourself and your Excel skills to learn a high demand skill?
- Do you find yourself repeatedly doing the same task in Excel or modifying a lot of files with the same process?
- In Excel, do you find yourself thinking there has got to be a better way to do this?
If you answered YES to any of the above questions, then Learn VBA for Excel is for YOU!
HOW DO I GET STARTED & HOW MUCH DOES IT COST?
Here is how I got started with VBA. I first heard about VBA at my undergrad college classes and this alone cost me thousands of dollars. But I only learned the basics and had to spend the next few years learning on my own. That entailed buying books, attending live training, and wasting countless hours searching Google for specific answers that might or might not have been there.
OR
I have cut through the crap and misinformation out there and created this online course for you. I have taken my years of experience and condensed it down to a concise, step-by-step approach, so you don’t have to wade through the muck as I did.
The videos are short segments on specific topics that are logically grouped together to maximize your learning. While learning VBA, I wished I could have attended my college classes again to relisten to my professor’s lecture. With this online course, you can do just that! You can pause the videos, rewatch them, and come back anytime because you have LIFETIME access.
You can watch the videos from anywhere: work computer, home computer, iPhone/Android devices, or any web browser.
Learn VBA for Excel
Duis fringilla sem nec lectus sodales, sed vehicula felis posuere. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Vestibulum hendrerit, turpis nec mattis pretium, velit tellus laoreet urna, id mattis lectus lectus eu turpis.
Cheat Sheets only
$47
One Time Payment
Full Program
$147
One Time Payment
With Coaching
$247
One Time Payment
My Personal No-Risk 30 Day Guarantee
My goal is to help as many people as possible learn VBA for 
Excel because of the extraordinary results I have experienced. You too can experience this by purchasing Learn VBA for Excel and completing the modules. To ensure your comfort about purchasing Learn VBA for Excel, if at any point during your first 30 days, you are not satisfied with it, you can receive a full refund.
Frequently Asked Questions
You can use any version of Excel for Windows. In the videos, I use 2016, but at work, I have Office 365 & 2013, and both work. I have been told that this all would apply for a Mac, but as I don’t have/use one, I cannot verify it. Depending on the demand for Mac users I might actually verify it, so if that is you, email me and let me know you want that!
This is where you can answer the above question in detail. Remember an FAQ is a question that most of your customers might have. Therefore, it is best to answer them in detail in order to show them that you have a solution for their queries.
Absolutely! They are all listed below each module.
The best answer is it depends. As it is self-paced you can go as fast or as slow as you want! I highly discourage people from binge-watching it from start to finish. There is just too much content to retain it. I would recommend taking about 6 weeks to go from start to finish. But you absolutely can go slower or faster.
Another point is that this journey never really ends. You can rewatch any video at any point in the future, whenever you want!
Each module has a comments section at the bottom of the page where you ask questions, and see what other questions/answers students have already asked or answered. Additionally, I will be in there to answer your questions.
I also send out emails with common questions that people have been asking.
Absolutely! In fact, if you don’t have two screens I would recommend watching the videos on a tablet and having Excel on your computer. Additionally, two screens are not a requirement.
Outside of the four 20 minute sessions, No.