The key topics that it covers include recorded macros, the macro editor, using and defining variables, creating custom forms and working with the various objects within Microsoft Excel.

INTRODUCTION TO EXCEL VBA

• Creating a Macro
• Running the Macro
• Examining the code behind the macro

INTRODUCING THE VISUAL BASIC EDITOR (VBE)

• Opening the Visual Basic Editor
• Recognizing Parts of the Visual Basic Editor
• Menus – View, Insert, Format, Debug, Run & Tools Menu

EXPLORING VISUAL BASIC FOR APPLICATIONS

• Objects and Collections
• Workbook and Worksheet Object
• Range Object and Cells Property
• Methods and Property
• Assigning Object Variables and Using Named Argument

DECLARING VARIABLES, CONSTANTS AND DATA TYPES

• Declaring Variables
• Defining Data Types
• Defining Constants
• Assigning Values to Variables
• Handling Strings
• Handling Dates and Times
• Handling Variants and Data Type Conversions

 MODULES AND PROCEDURES

• Modules and Procedures and Their Scope
• Calling Sub Procedures and Function Procedures
• Understanding Variable Scope and Lifetimes
• Exercises

 WRITING YOUR FIRST VBA FUNCTION IN EXCEL

• About User-Defined Functions
• A Function to Calculate the Area of a Rectangle
• A Function to Calculate Fuel Consumption
• Accessing Your Custom Functions

DECISION STRUCTURES

• IF … Then Statement
• IF … Then … Else
• Exercise: A Function to Calculate the Area of a Rectangle – (IF)
• Select Case
• Exercise: A Function That Gives the Name of the Day

 LOOP STRUCTURES

• For … Next
• For … Next Loop With Step
• Do While … Loop
• Do Until … Loop
• Do … Loop While
• Exercises 0..8

COMPLEX EXERCISES

• Adding Up the Coloured Numbers