Excel with VBA Training

Module 1- Recording macros and buttons

1. Absolute and relative recording
2. Where macros can be stored
3. Assigning macros to buttons

Module 2 - Selecting cells

1. Selecting cells (absolute)
2. Selecting cells (relative)
3. Selecting to the end of a block
4. Selecting a range by its corners

Module 3 - The VB code editor

1. Using Project Explorer
2. Creating modules
3. Basic subroutines and comments

Module 4 - Messages and variables

1. Input boxes and message boxes
2. Declaring variables
3. Option Explicit
4. Scope of variables
5. Constants

Module 5 - Visual Basic explained

1. The Excel object model
2. Objects and collections
3. Methods and properties
4. Getting help in VBA

Module 6 - Loops and conditions

1. Simple IF conditions
2. Multiple IF and SELECT / CASE
3. Three main types of loop

Module 7 - Looping over collections

1. Object variables
2. Looping over collections

Module 8 - Event handling

1. Assigning macros to events
2. Cancelling events

Module 9 - Functions

1. Declaring functions
2. Passing arguments

Module 10 - Debugging and error handling

1. Setting breakpoints
2. Stepping through macros
3. ON ERROR statements

Module 11 - Forms

1. Drawing forms
2. Attaching macros to controls
3. Validating form input

Module 12 - Links to other applications

1. Referencing other applications
2. Instantiating objects
3. Writing inter-application code