Module 1:Basic Essentials Object Oriented Recording Macros Branch Statements Interaction Variables (Value Type) Variables (Object Type) Collections Loop Statements Variables as Arguments Pivot Tables and Charts Module 2: Formulas and Arrays Dates and Calendars The Current-Region Property WorksheetFunction Property Formula Property FormulaR1C1 Custom Functions Array Functions 1D- and 2D-Arrays Customized Arrays Variant Arrays Module 3: Buttons, Forms, and More Importing and Exporting Buttons, Bars, Menus Application Events User Forms Data Entry + Mail Merge Custom Objects (Classes) Class Collections Error Handling Distributing VBA code VBA Monitoring VBA