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.
- 1Excel VBA Variables and Data Types: A Practical GuideLearn how to declare variables in Excel VBA, choose the right data type, use Option Explicit, and avoid the mistakes…
- 2Working with Ranges in Excel VBA: Cells, Offset, Resize and MoreEverything you need to read and write cells in Excel VBA: Range vs Cells, Offset, Resize, CurrentRegion, rows and columns…
- 3Format Cells with VBA: Fonts, Colours, Borders and Number FormatsFormat Excel cells from VBA: fonts, fill colours, borders, number and date formats, alignment and conditional formatting — with copy-paste…
- 4Decisions in VBA: If…Then, And/Or and Select CaseMake Excel macros decide: If…Then…ElseIf, logical operators And/Or/Not, and Select Case — with real examples and common mistakes.
- 55 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank RowsFive small, useful Excel VBA macros explained: the Mod operator, finding the second highest value, summing by cell colour, deleting…
- 6VBA Loops Explained: For, For Each, Do While and Do UntilLearn every Excel VBA loop — For…Next, For Each, Do While, Do Until — when to use each, how to…
- 7VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate WindowHandle errors in Excel VBA properly with On Error GoTo, find bugs with breakpoints, Watch and the Immediate window, and…
- 8VBA String Functions: Left, Mid, InStr, Replace, Split and MoreClean and reshape text in Excel VBA with Left, Right, Mid, Len, InStr, Replace, Trim, UCase, Split and Join —…
- 9Dates and timesComing soon
- 10EventsComing soon
- 11ArraysComing soon
- 12Sub vs FunctionComing soon
- 13The Application object and speedComing soon
- 14ActiveX controlsComing soon
- 15UserFormsComing soon