Level 1

Level 2

CD-ROM 1

1.0 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

2.0 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

3.0 Working with Variables and Constants

What Is a Variable?

Data Types

Using Constants

4.0 Visual Basic Editor Techniques

Writing Code Efficiently

Taking Advantage of IntelliSense

Optional and Named Arguments

CD-ROM 2

5.0 Mastering VBA Control Structures

Branching Structures

Looping Structures

6.0 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

7.0 Creating Reusable Procedures

Design Before Code

Writing the Same Code Once

8.0 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

Working with Methods

9.0 Handling Errors

Recognizing a Run-Time Error

The Error-Handling Standard

Exiting the Error Handler

Inline Error Handling

Combining Types of Error Handling

CD-ROM 3

10.0 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

11.0 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

12.0 Understanding Events

Events and Event Procedures

Which Objects Have Events?

User Form Events

Control Events

Product-Specific Events

Is There More?

13.0 Putting It All Together

Assembling the Pieces

Building a Solution in Excel

Using the Solution in Word

Where Are You Going From Here?

Appendices are included in the printed courseware:

Appendix A:

Calling VBA Procedures from the User Interface

Calling a VBA Procedure from the User Interface

Appendix B:

Comparison of VBA, Visual Basic, and Microsoft Access Forms

Confused Yet?

Loading and Unloading Forms

Events

Properties

Appendix C:

The Reddick VBA Naming Conventions

Changes to the Conventions

An Introduction to Hungarian

Tags

Constructing Procedures

Prefixes

Suffixes

Host Application and Component Extensions to the Conventions

Appendix D:

Resources

Where Can You Go for More Information?

CD-ROM 4

14.0 Exploring the Object Models of the Office Products

Figuring Out Object Models

Working with the Object Browser: Access

Knowing the Interactive Product: Word

Mining the Help File: Excel

15.0 Working with Active Objects

Active Properties in Office

Excel’s Active and Selection Properties

Word’s Active and Selection Properties

The Access Screen Object

16.0 Using Another Product's Features with Automation

Expanding Your Horizons Using Automation

Getting to the Object Model

Working with Data Using Automation

17.0 Advanced User Form Techniques

Restricting User Entry

Using List Boxes and Combo Boxes

Creating a Tabbed Dialog Box

Additional ActiveX Controls

CD-ROM 5

18.0 Techniques with VBA Variables

Scope, Lifetime, and Precedence

Passing by Value and by Reference

Optional Arguments

Creating Your Own Collections

19.0 Adding Data to Excel, Access, and Outlook

Using VBA to Work with Data

Adding Values to an Excel Worksheet

Adding ADO Data to Excel

Adding a Database Record with ADO

Adding an Item to Outlook

20.0 Charting Your Data

Excel’s Chart Object

Creating a Chart

Creating an Excel Chart from Access

21.0 Adding Content to Word and PowerPoint

Adding Text to a Word Document

Adding Content to PowerPoint

22.0 Giving Your Solutions to Others

Sharing the Wealth

Using Custom Toolbars

Office Templates and Add-Ins

Securing Your Code

Using Microsoft Office 2000 Developer to Deploy Solutions

Appendices are included in the printed courseware:

Appendix A:

Calling VBA Procedures from the User Interface

Calling a VBA Procedure from the User Interface

Appendix B:

Comparison of VBA, Visual Basic, and Microsoft Access Forms

Confused Yet?

Loading and Unloading Forms

Events

Properties

Appendix C:

The Reddick VBA Naming Conventions

Changes to the Conventions

An Introduction to Hungarian

Tags

Constructing Procedures

Prefixes

Suffixes

Host Application and Component Extensions to the Conventions

Appendix D:

Resources

Where Can You Go for More Information?