What VBA Is and When to Use It

A programming language that lives inside Excel

VBA stands for Visual Basic for Applications. It is built into Excel already — there is nothing to download and nothing to install. You write instructions, and Excel carries them out: the same clicks you would make by hand, but in a fraction of a second and in exactly the same way every single time.

Good reasons to write a macro

• Repetition — the same clean-up on a new export every Monday morning.
• Volume — 40,000 rows, where doing it by hand would cost you an afternoon.
• Consistency — a report that must come out formatted identically each month.
• Things formulas simply cannot do — creating sheets, saving files, printing, or showing a dialog box.

When not to use VBA

If a formula, a PivotTable or Power Query already solves the problem, use those instead. They are easier for a colleague to understand and they survive being emailed around. Macros need a macro-enabled file, they can be blocked by security settings, and somebody has to maintain them. Reach for code when the built-in tools genuinely run out of road — not before.

Macro-enabled files

A normal .xlsx workbook cannot store code at all. When you save a workbook that contains a macro you must choose Excel Macro-Enabled Workbook (.xlsm). If you save it as .xlsx, Excel silently throws the code away — with a warning that is very easy to click straight past. When you reopen an .xlsm file, Excel shows a yellow security bar; click Enable Content or the macros will not run.

What a macro actually is

A macro is just a named block of instructions stored in your workbook. You give it a name, Excel remembers it, and you run it whenever you like from the macro list, a keyboard shortcut, or a button on the sheet. Everything else in this course is detail on top of that one idea.