Beginner track

Beginner lessons

Open the VBE, write your first macros, and automate simple worksheet tasks.

1. 1

   Tour the Visual Basic Editor

   Open the VBE, understand the Project Explorer, and run your first Sub from the Immediate Window.

2. 2

   Option Explicit and Variable Declarations

   Require variable declarations and avoid silent bugs from typos.

3. 3

   Working with Ranges and Cells

   Reference ranges directly instead of Select/Activate.

4. 4

   Loop Through Worksheets

   Apply the same macro logic across every sheet in a workbook.

5. 5

   If and Select Case Statements

   Encode business rules with readable conditional logic.

6. 6

   For and For Each Loops

   Iterate rows, columns, and collections efficiently.

7. 7

   MsgBox and Basic User Feedback

   Confirm actions and report macro results to the person running the workbook.

8. 8

   Your First Workplace Macro

   Build a macro that validates a report tab and writes a summary status column.

Back to all tracks