- 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
Function procedures (work that returns a value)
This lesson covers the Function procedure, which can return a value such as a calculated result.
It is defined as Function Name(args) As ReturnType ... Name = value ... End Function. Assigning to the function's own name is what makes that value the return value.
The sample code defines Function AddTax(price As Long) As Long and returns the amount with sales tax added.
A common early stumble is forgetting to assign the result to the function name. Without AddTax = price + ..., the return value stays empty (0).
In professional work, it is handy to gather repeated calculations — sales tax, discounts — into Function procedures.
๐งช 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).