Tabellab
Beginner

VBA Basics

Open the editor, write your first working macro, and understand every line of it.

8 lessons 55 min Certificate

The first lesson is free — no account needed.

About this course

Learn VBA for Excel from scratch. This first course of the Excel VBA track opens the Visual Basic Editor, has you write and run your first macro, and explains every line: Sub procedures, variables with Dim and Option Explicit, MsgBox and InputBox, comments and what to do when code breaks. Each lesson ends with a short knowledge check.

Lessons

  1. What VBA Is and When to Use ItReading11 minFree
  2. The Visual Basic EditorReading6 min Pro
  3. Your First MacroReading7 min Pro
  4. Sub, End Sub, and Procedure NamesReading6 min Pro
  5. Variables, Dim, and Option ExplicitReading7 min Pro
  6. Talking to the User: MsgBox and InputBoxReading6 min Pro
  7. Comments and Readable CodeReading5 min Pro
  8. Running Code and Fixing It When It BreaksReading7 min Pro