VBA

Curriculum

8 chapters, each with a tutorial, a live example, a quiz, an exercise, a challenge, and class practice.

1. 1

   Introduction to VBA

   What VBA automates, and your first macro.

   preview
2. 2

   Variables & Data Types

   Dim, data types, and scope in VBA.

3. 3

   Loops

   For, For Each, and Do While.

4. 4

   Conditionals

   If/ElseIf/Else and Select Case.

5. 5

   Working with Ranges

   Reading, writing, and looping over cells.

6. 6

   Subs & Functions

   Reusable procedures that do or return something.

7. 7

   Error Handling

   On Error, and handling runtime failures gracefully.

8. 8

   UserForms Intro

   Building simple custom dialog boxes.