- 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
Working with arrays
This lesson covers the array, which handles several values together.
An array is declared as Dim name(count-1) As Type. Element indexes start at 0.
The sample code creates Dim fruits(2) As String — an array of three — assigns a fruit name to each, and then displays every element with a For statement.
A common early stumble is what Dim fruits(2) means. It means "indexes up to 2", so you actually get three elements: fruits(0), fruits(1), and fruits(2).
In professional work, reading several cells into an array first and then processing it runs considerably faster than reaching for each cell one at a time.
๐งช 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).