- 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
Writing a Sub procedure
This lesson covers the Sub procedure, the basic way VBA gathers work together.
A Sub procedure is a unit of work that returns no value, defined as Sub Name(args) ... End Sub. Other procedures call it with Call Name(args), or simply Name args.
The sample code defines Sub Greet(name As String) ... End Sub and calls it with Call Greet("Bob").
A common early stumble is the difference from the Function procedure covered in the next lesson. "A Sub when it just does work and returns nothing, a Function when you want a calculated result back" makes the choice easy.
In professional work, gathering logic into a Sub procedure in one place, rather than copying it around, is what keeps a macro maintainable.
๐งช 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).