VBA Sub explained the way it works: a Sub is a named action, your macro IS a Sub, and the parentheses rule for calling one is behind half the compile errors. Copy-paste examples, tested on Excel 365, 2021, 2019.
VBA Function explained: return a value by assigning to the function's own name (not Return), turn it into a custom worksheet function you can type in a cell, and know when to use a Function vs a Sub. Tested on Excel 365, 2021, 2019.
VBA ByRef vs ByVal explained: ByRef passes the original variable (changes stick), ByVal passes a copy. Why VBA defaults to ByRef and silently mutates your variable — and the one habit that prevents it. Tested on Excel 365, 2021, 2019.
VBA MsgBox explained the way it actually works: when to use brackets, how to read a Yes/No/Cancel answer, and why MsgBox is a decision gate — not a debugger. Copy-paste examples, tested on Excel 365, 2021, 2019.
Excel has two VBA InputBoxes, not one. Learn when the plain InputBox is enough, when Application.InputBox with a Type wins, and the Cancel trap that silently breaks both. Copy-paste examples, tested on Excel 365, 2021, 2019.
A VBA UserForm done right: the event-driven mindset, why your code 'disappears' after .Show, and the Unload-vs-Hide rule that decides whether you can read what the user typed. Copy-paste event code, tested on Excel 365, 2021, 2019.
Master the VBA Range object in Excel: Range vs Cells, .Value vs .Value2, dynamic ranges with End and CurrentRegion, and why you should never use .Select. 8 copy-paste examples. Tested on Excel 365, 2021, 2019.
Master VBA arrays in Excel: declare static and dynamic arrays, ReDim Preserve, UBound/LBound, and the one trick that makes macros 100× faster — reading a range into an array. 7 copy-paste examples. Tested on Excel 365, 2021, 2019.
Master the VBA Dictionary in Excel: early vs late binding, Add and Exists, plus the two patterns analysts really use it for — building unique lists and counting/grouping. 6 copy-paste examples. Tested on Excel 365, 2021, 2019.
VBA If Then Else is a checklist of independent questions. Learn the one trap that breaks it (VBA never short-circuits), the single-line vs block rule, and when to switch to Select Case — with copy-paste examples. Tested on Excel 365, 2021, 2019.
A VBA While loop is a promise that it will end — and you own that promise. Learn the three parts every While loop needs, why Do While beats While...Wend, and how to never hang Excel again. With copy-paste examples. Tested on Excel 365, 2021, 2019.
VBA Select Case is a switchboard, not a checklist. Understand the one rule that explains every Select Case bug, when to use it instead of ElseIf, and the Select Case True escape hatch — with copy-paste examples. Tested on Excel 365, 2021, 2019.
