Microsoft VBA Training - Introduction

Microsoft VBA Introduction – 2 Days

Getting Started with VBA

• What Is VBA?
• What Products Host VBA?
• What Does a VBA Application Look Like?
• Working with VBA in a Host Product
• How Do You Make VBA Code Happen?
• Starting With VBA by Recording Macros

Writing VBA Procedures

• Overview of the Visual Basic Editor
• Working with the Project Explorer
• Creating Simple Procedures
• Understanding the Code Window
• Customizing the Visual Basic Editor

Working with Variables and Constants

• What Is a Variable/Constant?
• Data Types

Visual Basic Editor Techniques

• Writing Code Efficiently
• Taking Advantage of IntelliSense
• Optional and Named Arguments

Mastering VBA Control Structures

• Branching Structures
• Looping Structures

Investigating Built-In VBA Functions

• VBA's Built-In Functions
• Using the Object Browser to Find VBA Functions
• Testing Functions in the Immediate Window
• VBA Functions You'll Probably Need

Creating Reusable Procedures

• Design before Code
• Writing the Same Code Once

Creating User Forms

• Working with User Forms
• Adding Controls to a User Form
• Setting Properties at Design Time
• Introducing Events
• Setting Properties at Run Time
• Working with Methods

Understanding Object Models

• Defining the Terms
• Using the Object Browser
• Working with Object Models in VBA
• Object Variables
• Special VBA Control Structures for Objects
• Working with the Office Object Models

Handling Errors

• Recognizing a Run-Time Error
• The Error-Handling Standard
• Exiting the Error Handler
• Inline Error Handling
• Combining Types of Error Handling

Debugging Your VBA Code

• Debugging Your Code
• Setting a Breakpoint
• Stepping Through Code
• Checking Values at Run Time
• Watch Expressions
• The Call Stack
• The Debugging Process

Understanding Events

• Events and Event Procedures
• Which Objects Have Events?
• User Form Events
• Control Events
• Product-Specific Events
• Is There More?

Putting It All Together

• Assembling the Pieces
• Building a Solution in Excel
• Using the Solution in Word

Investigating Built-In VBA Functions

• VBA's Built-In Functions
• Using the Object Browser to Find VBA Functions
• Testing Functions in the Immediate Window
• VBA Functions You'll Probably Need