Learn VBA Online

Tutorial for Beginners

Interactive VBA Tutorial

Our interactive VBA tutorial is perfect for beginners or experienced users looking to brush up on their skills. Create a free account to save your progress and much more!

About the VBA Tutorial

Interactive Tutorial Course Contents

Chapter Progress Complete?

1. VBA Basics

Introduction to the basics of working with VBA for Excel: Subs, Ranges, Sheets, & More

Login to See Login to See

2. Variables

Declaring variable types, assigning object and non-object variables

Login to See Login to See

3. Conditional Logic

Comparing values and conditions, if statements and select cases

Login to See Login to See

4. Loops

Repeat processes with For loops and Do While or Do Until Loops

Login to See Login to See

5. Adv Cell Referencing

Working with cells, rows, and columns to copy/paste, count, find the last used row or column, assigning formulas, working with sheets

Login to See Login to See

6. Msg & Input Boxes

Communicate with the end-user with message boxes and take user input with input boxes

Login to See Login to See

7. Events

Trigger procedures to run when certain “eventsâ happen like activating a worksheet, or changing cell values

Login to See Login to See

8. Settings

Speed up your code and improve the user experience

Login to See Login to See

9. Adv Procedures

Public variables, functions, and passing variables to other procedures.

Login to See Login to See

10. Arrays

Programmatically work with series of values without needing to interact with Excel objects.

Login to See Login to See

Create Account

VBA Tutorial PDF

VBA Tutorial PDF

VBA Tutorial PDFs

We converted our Interactive VBA Tutorial into a 70 page PDF. The PDF is colorful, easy to navigate, and filled with examples. You'll also receive access to our PowerPoint and Word VBA Tutorials (Access and Outlook coming soon)!

  • Excel / General VBA Tutorial (70 pages)
  • Word VBA Tutorial (17 pages)
  • PowerPoint VBA Tutorial (17 pages)

VBA Examples Add-in

VBA Add-in For Beginners

VBA Examples Add-in

Our free VBA Add-in installs directly into the VBA Editor, giving you access to 150 ready-to-use VBA code examples for Excel.

Simply click your desired code example and it will immediately insert into the VBA code editor.

This is a MUCH simplified version of our premium VBA Code Generator.

VBA Cheatsheets

Learn VBA Cheat Sheet

VBA Cheat Sheets

PDF "Cheat Sheet" containing the most commonly used VBA Commands and syntax. Print the PDF or save it to your computer for easy reference!

In-Depth VBA Guides

VBA "How-To" Articles

Visit Our VBA Code Examples
Page for 200+ VBA Tutorials

Create Account