1. Getting Started with VBA Excel
• Introducing Visual Basic for Applications
• Displaying the Developer Tab on 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 Visual Basic Editor
• Understanding Macro Security

2. 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 Procedures
• Naming Procedures
• Working with the Code Editor

3. Understanding Objects
• 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

4. 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

5. 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

6. Working with Forms and Controls
• Understanding UserForms
• Using the Toolbox
• Working with the UserForm Properties, Events, and Methods
• Understanding Controls
• Setting Control Properties in the Properties Window
• Working with the Label Control
• Working with the TextBox 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

7. Working with the PivotTable Object
• Understanding PivotTables
• Creating a PivotTable using Worksheet Data
• Working with Pivot Objects
• Working with the PivotFields Collection
• Assigning a Macro to the Quick Access Toolbar

8. Debugging Code
• Understanding Errors
• Using Debugging Tools
• Setting Breakpoints
• Stepping through Code
• Using Break Mode during Run mode
• Determining the value of Expressions

9. Handling Errors
• Understanding Error Handling
• Understanding VBA’s Error Trapping Options
• Trapping Errors with the On Error statements
• Understanding the Err Object
• Writing an Error-Handling Routine
• Working with Inline Error Handling

10. VBA Macros Security and Protection in Excel
• Password Protecting the code
• Hiding and very hiding Worksheets
• Protecting the Sheet
• Protecting the Workbook
• Password Protecting a single VBA Procedure