- 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
Error handling (On Error)
This lesson covers On Error, which deals with errors at run time.
Writing On Error GoTo LabelName jumps to the place you specify when an error occurs. Err.Description tells you what the error was.
The sample code catches the error raised by dividing by zero with On Error GoTo ErrorHandler and displays the error message.
A common early stumble is not appreciating how risky a macro without error handling is. Without it, an unexpected error stops the macro dead and leaves the user staring at an impenetrable error screen.
In professional work, macros used in the business always build in error handling, ready for the unexpected — a missing file, a sheet that does not exist.
๐งช 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).