- 01Setting up (what you'll need)
- 02Your first output (MsgBox)
- 03Variables (Dim)
- 04Branching (the If statement)
- 05Repeating (the For statement)
- 06Repeating (the Do While statement)
- 07Writing a Sub procedure
- 08Function procedures (work that returns a value)
- 09Reading and writing cells (Range and Cells)
- 10Working with arrays
- 11Working with strings
- 12The With statement
- 13Object variables and working with worksheets
- 14Looping over cells (For Each)
- 15Error handling (On Error)
- 16The Select Case statement
- 17Arguments (ByVal and ByRef)
- 18Working with collections (Collection)
- 19Recording macros and event procedures
- 20[Project] Build a small inventory sheet
Branching (the If statement)
This lesson covers how to write an If statement in VBA.
You branch with If condition Then ... ElseIf condition Then ... Else ... End If. What is distinctive is that the equivalent of else if is a single word: ElseIf.
The sample code uses If / ElseIf / Else to show one of three messages depending on score.
A common early stumble is forgetting End If. A short If that fits on one line can leave it out, but an If spread over several lines must always be closed with End If.
In professional work, If statements come up constantly for branching on the value of a cell.
๐งช This site can't compile or run VBA directly, so it checks on the spot whether what you typed matches the reference code (scoring happens entirely in your browser โ nothing is sent anywhere).