Excel VBA Course: 15 Free Lessons

📊
← All courses

Excel VBA Course: 15 Free Lessons

A free, practical Excel VBA course written from real office work. Start at lesson 1 or jump to the topic you need — every lesson has copy-ready code, and many link to the interactive VBA Playground.

  1. 1Excel VBA Variables and Data Types: A Practical GuideExcel VBA course lesson 1: open the VBA editor, write your first macro, declare variables with Dim, choose the right…
  2. 2Working with Ranges in Excel VBA: Cells, Offset, Resize and MoreExcel VBA course lesson 2: refer to cells with Range and Cells, find the last row and column, move with…
  3. 3Format Cells with VBA: Fonts, Colours, Borders and Number FormatsExcel VBA course lesson 3: format reports with VBA — fonts, fill colours with RGB, borders, alignment, number formats for…
  4. 4Decisions in VBA: If…Then, And/Or and Select CaseExcel VBA course lesson 4: make macros decide with If…Then…Else, ElseIf, And, Or and Not, check empty and error cells,…
  5. 55 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank RowsExcel VBA course lesson 5: five small, reusable macros explained line by line — every Nth row with Mod, second-highest…
  6. 6VBA Loops Explained: For, For Each, Do While and Do UntilExcel VBA course lesson 6: repeat work with For…Next, Step, For Each over ranges and sheets, Do While/Until loops, Exit…
  7. 7VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate WindowExcel VBA course lesson 7: read VBA error messages, step through code with F8, use breakpoints, the Immediate and Locals…
  8. 8VBA String Functions: Left, Mid, InStr, Replace, Split and MoreExcel VBA course lesson 8: clean and reshape text with VBA — Len, Left, Right, Mid, InStr, InStrRev, Replace, Trim,…
  9. 9VBA Arrays: Make Your Macros 100 Times FasterExcel VBA course lesson 9: read a whole range into an array, work in memory, write it back once. Static…
  10. 10VBA Subs and Functions: Reusable Code and Your Own Excel FormulasExcel VBA course lesson 10: split a big macro into small Subs, pass arguments ByVal and ByRef, return values with…
  11. 11VBA Worksheets and Workbooks: Add, Copy, Loop, Save SafelyExcel VBA course lesson 11: refer to workbooks and sheets without ActiveSheet bugs, loop through every sheet, add and rename…
  12. 12VBA Events: Macros That Run by Themselves (Worksheet_Change and More)Excel VBA course lesson 12: Workbook_Open, Worksheet_Change, SelectionChange and BeforeSave events — timestamps when a cell is edited, auto-uppercase codes,…
  13. 13VBA UserForms for Beginners: Build a Data-Entry Form Step by StepExcel VBA course lesson 13: design a UserForm, fill combo boxes from a sheet, validate inputs, write a new row…
  14. 14VBA Collections and Dictionaries: Unique Lists, Counts and Fast LookupsExcel VBA course lesson 14: when to use a Collection or a Scripting.Dictionary, build unique lists, count and total by…
  15. 15VBA Files and Folders + Final Project: Combine a Month of Reports AutomaticallyExcel VBA course lesson 15: loop through files with Dir, create folders, check whether files exist, read text/CSV files, then…