Visual Basic for Applications is the integrated programming language used in Excel to create Excel Macros. In this class we take an in-depth look at this language starting from the ground up, and how it is applied to developing programs & automating operations in Excel. 

For the best results, participants should be familiar with the topics covered in the Excel Introduction, Excel Intermediate Part 1, and Excel Intermediate Part 2 classes.

• Why use VBA if I can record macros in Excel?
• Recoding a Simple macro
• Reviewing the code
• Familiarisation with the VBA environment
• Running Code from the VB Editor window
• Getting help on code
• Stepping through a procedure
• Using a Break point
• Communicating with the User

• Modules and procedures
• Components of your code
• Objects, Collections, Properties and methods
• Using the Excel Object model

• Working with variables and constants
• Using Data types
• Working with operators and expressions
• Implicit and Explicit Declarations
• Variable Scope – Procedural, Modular or Public
• Passing variables by Value
• Passing variables by Reference
• Using Arrays

• Workbook objects and methods
• Creating a new workbook
• Adding and Renaming Sheets
• Saving and Closing a Workbook

• Mathematical functions
• Date and time functions
• String functions
• Using Excel functions in VBA code

• Creating User Defined functions
• Using user-defined functions in a worksheet
• Declaring Multiple arguments in a function
• Creating a Function Library

• Do Until and Do While loops
• Looping at least once
• For Next Loop
• For Each Loops with collections

• Using IF to make decisions
• Testing for multiple conditions
• Establishing Flow control
• Branching
• Call other procedures

• Adding Names
• Deleting Names
• Creating Hidden Names
• Checking for the Existence of a Name