Module 1: Getting started
-
Introducing Visual Basic for Applications
-
Recording a Macro
-
Running a Macro
-
Absolute or Relative Cell Referencing
-
Saving and Opening Files with Macros
-
Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, and Buttons
-
Editing a Macro in the Visual Basic Editor
-
Understanding the Development Environment
-
Customising the Editor
-
Tips for General Typing in VBA
-
Using Visual Basic Help
Module 2: Working with Procedures
-
Program Design
-
Understanding Modules
-
Naming Rules
-
Creating a Module
-
Understanding Procedures
-
Programming Macro Concepts
-
Creating a Subroutine
-
Creating a Function
-
Understanding Arguments
-
Exiting Procedures
-
Calling Procedures
Module 3: Understanding Objects, Properties, Methods, and Events
-
Understanding Objects Properties, Methods, and Events
-
Navigating the Object Hierarchy
-
Understanding Collections
-
Accessing a Member of a Collection
-
Understanding Hierarchy
-
Using the Object Browser
-
Using the With Statement
-
Working with Properties
-
Working with Methods
-
Creating an Event Procedure
-
Reserved Macro Names
Module 4: Using Expressions, Variables and Intrinsic Functions
-
Understanding Expressions and Statements
-
Declaring Variables
-
Understanding Data Types
-
Determining the Value of Variables
-
Working with Variable Scope
-
Using Built-in VBA Functions
-
Understanding Constants
-
Using Message Boxes
-
Controlling the Answer to a Message Box
-
Using Input Boxes
-
Declaring and Using Object Variables
Module 5: Controlling Program Execution
-
Understanding Control-of-Flow Structures
-
Using the If...End If Decision Structures
-
Nested If Statements
-
Using the Select Case ... End Select Structure
-
Using the Do ... Loop Structure
-
Using the For ... Next Structure
-
Using the For Each ... Next Structure
-
Guidelines for Use of Control-of-Flow Structures
Module 6: Working with Forms and Controls
-
Understanding UserForms
-
Creating a Form
-
Displaying and Removing a Form
-
Aligning and Sizing Controls
-
Using the Toolbox
-
Working with a Form's Properties, Methods, and Events
-
Working with Form and Control Properties, Methods and Event
-
Setting the Tab Order
-
Populating a Control
Module 7: Debugging and Handling Errors
-
Understanding Errors
-
Using Debugging Tools
-
Setting Breakpoints and Using Break Mode
-
Stepping Through Code
-
Trapping Errors with the On Error Statement
-
Understanding the Err Object
-
Working with Inline Error Handling
-
Writing an Error-Handling Routine