📗 VBA
Learn VBA from the Basics
VBA — the language built into Excel for automating the work you would otherwise do by hand — taught from the ground up across 20 lessons. Since VBA runs inside Office rather than in a browser, each lesson checks whether what you typed matches the reference code, giving you instant feedback without ever leaving the page.
What is VBA used for?
VBA ships inside Microsoft Office, so if you have Excel you already have everything you need — press Alt+F11 and start writing. That accessibility is why it remains so widely used in accounting, sales, and administration, where a macro can turn an afternoon of copying between spreadsheets into a single click. It is often the first language someone learns because their own job gave them a reason to.
Common uses & related roles:
- Automating repetitive Excel work
- Building reports and aggregating data
- Automating Word and Access alongside Excel
- Office and back-office staff
- 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