Getting Started

Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro

Saving a Macro-Enabled Workbook Running a Macro

Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help

Closing the Visual Basic Editor Understanding Macro Security

Working with Procedures and Functions

Understanding Modules Creating a Standard Module Understanding Procedures Creating a Sub Procedure Calling Procedures

Using the Immediate Window to Call Procedures Creating a Function Procedure

Naming Procedures

Working with the Code Editor

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 Understanding Expressions and Statements Declaring Variables

Understanding Data Types Working with Variable Scope Using Intrinsic Functions Understanding Constants 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

Guidelines for use of Control-of-Flow Structures

Understanding UserForms Using the Toolbox

Working with UserForm Properties, Events, and Methods Understanding Controls

Setting Control Properties in the Properties Window Working with the Label Control

Working with the Text Box Control

Working with the Command Button Control Working with the Combo Box Control Working with the Frame Control

Working with Option Button Controls Working with Control Appearance Setting the Tab Order

Populating a Control Adding Code to Controls Launching a Form in Code

Understanding PivotTables

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 Understanding Errors Using Debugging Tools Setting Breakpoints Stepping through Code

Using Break Mode during Run mode Determining the Value of Expressions

Understanding Error Handling 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

Programme scope, delivery arrangements and suitability are confirmed during enquiry.