- 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
Reading and writing cells (Range and Cells)
This lesson covers the basics of working with Excel cells from VBA.
You point at a particular cell with Range("A1") or Cells(1, 1), and read or write its contents through the .Value property.
The sample code writes a value into a cell with Range("A1").Value = 100 and displays what it reads back with Range("A1").Value.
A common early stumble is choosing between Range("A1") (A1 notation) and Cells(1, 1) (row and column as numbers). Range suits a fixed position; Cells is handier when a For loop is walking down the rows.
In professional work, most of an Excel macro is built around reading and writing cells — it is the most basic and most important VBA operation there is.
๐งช 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).