You can write better macros in half the time

Get free VBA tutorials sent directly to Excel

I want to help you write macros in Excel with my Excel VBA tutorials and VBA code examples. That's why I developed this unique 3-part free Excel training program to help you quickly learn VBA in a natural setting: right inside Excel.

Ryan Wells
Hi, I'm Ryan Wells

How to write macros in Excel

Part 1 of my free online Excel training program will help you learn VBA fundamentals. Follow each VBA tutorial below to learn how to write macros for Excel.

How to create a macro in Excel

1

Enable Excel Developer Tab

2

Open VBA Editor in Excel

3

Writing a macro

4

Using the Macro Recorder

5

Commenting in VBA

Navigating your spreadsheet with VBA

1

Using the VBA Range object

2

How to select cells with VBA

3

Controlling different workbooks

4

Macros to control worksheets

Understanding VBA Variables

1

VBA Variable Types

2

How to Declare Variables

3

Variable Scope and Lifetime

4

Understanding Option Explicit

Ready for Advanced VBA Training?

To access Parts 2 and 3 of my free online VBA training program, enter your email address below.



How can I learn Excel VBA?

How I taught myself VBA

A story of what not to do

One day I decided I would try to program everything I do in Excel. And I mean everything.

When I first started out, I would spend 10x more time Googling how to do something with VBA than it would take me to actually do it manually in Excel! I wasn't born knowing how to find the last used row in Excel. I had to learn!

For months, I would read VBA forums and Google my VBA questions. It was an extremely slow, extremely painful process. I wasn't even good yet, and I was already getting bored trying to program the same things over and over again with VBA.

It was at this point that I began using VBA forums as a tool to spur my creativity. As I got comfortable writing macros, I would read about the challenges other people were having with Excel VBA, and I would sharpen my skills by trying to solve their problems.

It wasn't easy at first, but it gave me a way to practice in areas of VBA that I normally wouldn't use. Not only that, it introduced me to VBA concepts I had no idea were even possible! For instance, did you know you can make Excel talk with VBA?

How you should learn VBA

Learn from my mistakes

I developed a 3 part system to make learning VBA fast and easy for you. All you have to do is follow these steps:

  1. Complete my Free Online Excel Training Program, which is designed to teach you the fundamentals of writing macros in Excel.
  2. Install the wellsrPRO Excel Add-in.
  3. Click each VBA tutorial that appears on the wellsrPRO Excel ribbon.

wellsrPRO truly is the best way to learn VBA. I made this tool so you don't have to make the same mistakes I did when I taught myself VBA.

wellsrPRO gives you access to all the VBA tutorials I've posted on this site without ever leaving Excel. From the add-in, you'll be able to import the VBA code examples directly into your spreadsheet and save the ones you use regularly.

Motivation for the journey

Everybody needs a reason to stay motivated when learning a new skill. Let me share a few inspirational ideas to keep you going.

  • You'll make fewer mistakes in Excel because VBA will do your job automatically.
  • Your powerful workbooks will get you recognized as the Excel guru in your office.
  • You'll know how to make yourself stand out to your boss with incredible VBA tricks, like creating an Excel Splash Screen for your spreadsheets.
  • You can shave hours off your workday by automating mundane tasks.