Introduction to Excel Macros (half day)

Session 1 
Using Excel's macro recorder -  Running recorded macros - Editing code in the VBA(Visual Basic for Applications) editor - Adding comments to code - Assigning a macro to a button

Session 2
The limitations of the macro recorder - An introduction to variables - The VBA data types (the Dim statement) - Assigning values to variables

Session 3
The structure of VBA: Modules and Procedures Objects, Properties and Methods

Session 4
Using the If statement - Using the Select Case statement

Session 5
Looping through code using ForNext

Session 6
Looping through code using DoWhile and DoUntil

Session 7
Debugging code - Stepping through code Using the watch window and break points

Session 8
Customising Message Boxes Using Input Boxes

Session 9
Working with User Forms    

Project: Developing a simple database enquiry system