CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

ATVBA61 - VBA Foundations For Microsoft Office - Level 1

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

ITCourseware’s VBA for Microsoft Office courseware will teach you to start thinking in terms of how you can make your work life simpler. This courseware gets you going in VBA by showing you the tools to start automating little tasks right away.

Click here for a printer-friendly version of this page

Prerequisites

Detailed Class Syllabus

Prerequisites:
Familiarity with Microsoft Office.

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?

Data Types

Working with Arrays

Using Constants

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 Functions

VBA's Built-In Functions

Using the Object Browser to Find VBA Functions

Testing Functions in the Immediate Window

Interacting with the Computer

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

Formatting Controls

Setting Properties at Design Time

Introducing Events

Setting Properties at Run Time

Additional ActiveX Controls

Working with Methods

Working with List Boxes and Combo Boxes

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

Working with Error Handling

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

Where Are You Going From Here?