Conditional Statements in Macro Code

IF-THEN, IF-THEN-ELSE,
ELSEIF, SELECT CASE

Looping in Macro Code

DO WHILE LOOP, DO UNTIL LOOP,
FOR…NEXT LOOP, FOR…EACH LOOP, EXIT FOR

Error Handling in Macro Code

Enable Error Handling
ON ERROR Statements

User Forms

Create User Forms
User Form Controls
Write code to activate a form
Create a subroutine to open a form

Custom Functions

Create a custom function
Custom Functions in Excel worksheets

Debugging Macro Code

Message Boxes when Debugging Code
VBA Debug Toolbar
Compile VBA Projects

Add-Ins

Built in Add-Ins
Custom Add-Ins
Create, Modify, Load, Unload and Delete Custom Add-Ins

Optimising Macros

Display Alerts
Screen Updating

Simple Rules for Writing Macros

Summary Guide to Useful Objects, Methods and Properties