← Back to Tools
VBA

Tool

VBA

Automate Excel and other Office apps

Learn VBA syntax, loops, and working with Excel ranges via macros.

8

Chapters

17

Hours (estimated)

1

Self-paced

Part-time

About 6 weeks

1 hour a day, 3 days a week

Full-time

About 2 weeks

3 hours a day, 3 days a week

Estimated from 8 chapters (notes, practice, labs, quiz, exercise, and challenge) plus the final exam. Go at your own pace.

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.

  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.

Start learning — it's free →

VBA is free to study, self-paced. Pass the final exam to earn an optional Certificate of Completion for $40.