VBA tutorial

Automate spreadsheet and office workflows with readable macros.

vba16 lessons

Sub Hello()
  MsgBox "Hello from VBA"
End Sub

Designed forAnalysts and office automation builders

Learning formatShort explanations, examples, practice connections

Source privacyCompiler text remains inside your browser

COURSE CURRICULUM

16 lessons in a clear order

Finish one section at a time or jump directly to a concept you need.

Foundations

VBA editors, modules, and macro security

Learn how vba editors, modules, and macro security works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Statements, procedures, and Option Explicit

Learn how statements, procedures, and option explicit works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Core concepts

Variables, constants, scope, and object references

Learn how variables, constants, scope, and object references works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Variants, ranges, arrays, and user-defined types

Learn how variants, ranges, arrays, and user-defined types works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Operators, worksheet functions, and comparison

Learn how operators, worksheet functions, and comparison works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Control flow

If, Select Case, and workbook decisions

Learn how if, select case, and workbook decisions works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

For, For Each, Do, and range traversal

Learn how for, for each, do, and range traversal works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Data and composition

Subs, functions, events, and parameters

Learn how subs, functions, events, and parameters works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Arrays, collections, dictionaries, and ranges

Learn how arrays, collections, dictionaries, and ranges works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Strings, dates, and formatted cells

Learn how strings, dates, and formatted cells works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Reliability and structure

Error handling, cleanup, and validation

Learn how error handling, cleanup, and validation works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Modules, references, forms, and workbook structure

Learn how modules, references, forms, and workbook structure works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Applied engineering

Excel objects, worksheets, and application state

Learn how excel objects, worksheets, and application state works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Files, Office automation, and safe boundaries

Learn how files, office automation, and safe boundaries works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Testing macros on copied workbooks

Learn how testing macros on copied workbooks works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.

Capstone

Capstone: a reversible spreadsheet automation

Learn how capstone: a reversible spreadsheet automation works in VBA, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.