- 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
Variables (Dim)
This lesson covers the basics of declaring variables in VBA.
A variable is declared as Dim name As Type. The most common types are String (text), Integer (whole numbers), and Double (decimals).
The sample code declares two variables, Dim name As String and Dim age As Integer, and assembles a message by joining strings with the & operator.
A common early stumble is that Dim can be omitted at all. VBA runs without declarations by default, but writing Option Explicit at the top of a module heads off bugs caused by a forgotten declaration (usually a typo).
In professional work, always writing Option Explicit is treated as basic good manners for building macros you can rely on.
๐งช 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).