Want to write macros like a pro?

If you want to know how experts write better macros in half the time, grab both our VBA Developer Kit and our Big Book of Excel VBA Macros for free using the form below.

Sure, I'll take a free VBA ebook and Developer Kit
Ryan Wells
Hi, I'm Ryan Wells

How to write macros in Excel

If you're new to VBA, you should start with these fundamentals. Once you're comfortable with them, you'll be able to follow our advanced VBA tutorials with ease.

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

Don't settle for average

I was complacent with my foundational VBA knowledge for too long. Truth is, it's not enough. When you push yourself to learn more about writing macros, people notice. I want you to join over 13000 people pushing themselves to get better at VBA so they can automate more tasks, free up more time and become more valuable at work.


Yes, I want to improve my VBA skills and become a better programmer.


Industry Leading VBA Training Material

VBA Cheat Sheets

$120 $57

Ultimate VBA Training Bundle

The most affordable way to own all six of our comprehensive reference guides is with this bundle of over 200 tips and macros covering the 125 most important topics in VBA.

$20.00

VBA UserForms

Our VBA UserForms Cheat Sheet describes all 16 UserForm controls and explains which properties you need to modify to get them looking sharp.

$20.00

VBA Fundamentals

With over 30 useful tips covering the 25 most important topics in VBA, this essential cheat sheet is designed to help you overcome the "growing pains" from learning VBA.

$20.00

VBA Logic and Loops

Our Logic and Loops Cheat Sheet fully explains complex conditional statements and describes each of the 5 VBA loop structures with helpful examples and syntax highlighting.

$20.00

VBA Arrays Cheat Sheet

This cheat sheet is full of premium tips and tricks for working with arrays. It features over 20 macro examples and is setup in a beautiful multi-column reference guide

$20.00

Using VBA Strings

The largest VBA Cheat Sheet we've ever made, this guide explains every string manipulation function and even covers complex operations, like executing a regex with pattern recognition.

$20.00

File I/O Cheat Sheet

This 3-page reference guide includes everything you need to know about File I/O, including multiple ways to read from files, write to files, append to files, and prepend to files.