Excel and Macro’s, the basics

Recording visual basic “Macros” | The visual basic environment | Assigning code to buttons, menu’s and toolbars | The “Personal Macro Workbook”

Writing visual basic code

Modules and procedures (private and public) | Properties and methods | Variables | Dim | If…Then…Else | Select Case  | Do…Loop

Testing and debugging applications

Using the debug window | Starting, halting and tracing execution | Resolving compile and run-time errors | Working with breakpoints

Error handling and trapping

On error statement | Resume points

Delegates will be encouraged to write their own VBA code to help them learn and appreciate what they are doing