Getting Started

• Introducing Visual Basic for Applications
• Recording, running, and editing a macro
• Saving a macro-enabled workbook
• Understanding the development environment
• Understanding macro security

Working with Procedures and Functions

• Understanding modules and procedures
• Creating a standard module
• Creating a sub-procedure
• Calling procedures
• Using the immediate window to call procedures
• Creating a function procedure
• Naming procedures
• Working with the code editor

Understanding Objects

• Navigating the Excel object hierarchy
• Understanding collections
• Using the object browser
• Working with properties
• Using the with statement
• Working with methods
• Creating an event procedure

Using Expressions, Variables, and Intrinsic Functions

• Declaring variables
• Understanding data types
• Working with variable scope
• Using intrinsic functions
• Using intrinsic constants
• Using message boxes
• Using input boxes
• Declaring and using object variables

Controlling Program Execution

• Understanding control-of-flow structures
• Working with Boolean expressions
• Using the if...end if decision structures
• Using the select case...end select structure
• Using the do...loop structure
• Using the for...to...next structure
• Using the for each...next structure

Working with Forms and Controls

• Understanding UserForms
• UserForm properties, events, and methods
• Understanding controls
• Setting control properties
• Working with a variety of controls
• Setting the tab order
• Populating a control
• Adding code to controls
• Launching a form in code

Working with the PivotTable Object

• Creating a PivotTable using worksheet data
• Working with the PivotTable objects
• Working with the PivotFields collection
• Assigning a macro to the Quick Access toolbar

Debugging Code

• Using debugging tools
• Setting breakpoints
• Stepping through code
• Using break mode during run mode
• Determining the value of expressions

Handling Errors

• Understanding VBA's error trapping options
• Trapping errors with the on error statement
• Understanding the err object
• Writing an error-handling routine
• Working with inline error handling