Tabellab
Beginner

Logic & Loops

Make your macros decide for themselves and repeat work across thousands of rows.

8 lessons 55 min Certificate

The first lesson is free — no account needed.

About this course

Make your macros decide and repeat. This course covers VBA logic with If, ElseIf and Select Case, and VBA loops with For…Next, For Each, Do While and Do Until, plus Exit statements, guard clauses and nested loops that walk across rows and columns.

Lessons

  1. If, ElseIf and ElseReading10 minFree
  2. Building ConditionsReading6 min Pro
  3. Select CaseReading6 min Pro
  4. For ... NextReading7 min Pro
  5. For EachReading6 min Pro
  6. Do While and Do UntilReading7 min Pro
  7. Exit, Guard Clauses and SkippingReading6 min Pro
  8. Nested Loops Over Rows and ColumnsReading7 min Pro