- 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
Your first output (MsgBox)
This lesson covers the basics of showing output in VBA with MsgBox.
MsgBox "..." displays a pop-up window on screen. VBA is the language for automating Excel, and code is written in units of work called Subs.
In the sample code, a single line — MsgBox "Hello, VBA!" — sits inside the fixed Sub Hello() ... End Sub frame.
A common early stumble is forgetting Sub and End Sub. Every piece of VBA has to be wrapped in that pair, and leaving one out is an error.
In professional work, VBA macros are used widely across accounting, sales, and many other departments to automate repetitive work in Excel.
๐งช 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).