Interactive VBA Tutorial


AutoVBA contains an interactive VBA tutorial:

interactive VBA Tutorial

Access the tutorial from the VBA Code Tools toolbar:

interactive VBA Tutorial

It covers:

  • VBA Basics
  • Variables
  • Conditional Logic
  • Loops
  • Advanced Cell Referencing
  • MsgBoxes and InputBoxes
  • Events
  • Settings
  • Advanced Procedures
  • Arrays

How it works

The tutorial will contain a lesson with examples. At the end of the lesson you'll be asked to complete an exercise:

interactive VBA Tutorial lesson

Code will appear in your VBA Editor and you will enter your solution there:

interactive VBA Tutorial lesson exercise

Press Enter and your answer will be evaluated. If it's correct you'll be prompted to proceed to the next question:

interactive VBA Tutorial lesson correct

and the next exercise will appear in your VBA Editor:

interactive VBA Tutorial lesson next lesson

If you are struggling with an exercise, you can hover your mouse over the Help button to see the correct answer:

interactive VBA Tutorial help

Or you can click Help and the answer will be entered into the VBA Editor:

interactive VBA Tutorial help correct answer

VBA Tutorial track progress