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
