Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     

Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
VBA for Office
with Jan Fransen

View the Course Outline
(Level 1 | Level 2)

Our VBA training is designed to help you to be more productive in Microsoft Access, Microsoft Excel, and Microsoft Word by teaching you about Visual Basic for Applications—the common programming language that helps you make Microsoft Office do more work for you.

Course includes 18+ hours of total training time...

  • 5 CDs
  • Over 6 hours of media run time
  • Over 700 pages of courseware on CD-ROM
  • Step-by-step hands-on-labs
  • Sample code
Format Sessions Retail Price
VBA for Office

 5 CD-ROMs

CD-ROM & Books

 5 CD-ROMs + Printed Books

Read about Jan Fransen .
Course Outline (Outlines are subject to change.)

Level 1: VBA Foundations for Microsoft Office

Sessions Run Time Pages
3 CDs 3 hours 400

Level 1 VBA for Microsoft Office CD-ROMs will teach you to start thinking in terms of how you can make your work life simpler. The Level 1 CD-ROMs get you going in VBA by showing you the tools to start automating little tasks right away.

In this course, you will learn to:

  • Get familiar with the Visual Basic Editor included in all of the Microsoft Office products.
  • Learn to write VBA procedures that do complex calculations.
  • Find out how to use a VBA procedure in an Access query or an Excel spreadsheet formula.
  • Create custom toolbars and buttons to call your VBA code.
  • Design forms that act as dialog boxes for your VBA solutions.
  • Learn about events in forms and in the Office products and how you can use them to customize the way each product works.
  • Find out about object models and how they are organized.

To get the most out of VBA Foundations for Microsoft Office, you must be very comfortable with the interactive aspects of a Microsoft Office product such as Microsoft Access, Microsoft Excel, Microsoft PowerPoint, or Microsoft Word. Prior programming experience is helpful, but not required.


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


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


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?

back to top

Level 2: VBA Solutions for Microsoft Office

Sessions Run Time Pages
2 CDs 2 hours 300

Understanding how VBA works opens up a whole world of possibilities for making tasks with your computer easier. The Level 2 VBA CD-ROMs teach you how to begin solving more complex work problems.

In this course, you will learn to:

  • Learn about the Object Browser and online Help-the tools you’ll need to figure out any product’s object model.
  • Find out how to determine what objects the user is working with when your code runs.
  • Get familiar with the techniques you’ll need to create solutions that use the features of more than one product.
  • Learn how to use combo boxes and list boxes in the forms you create.
  • Find out how to open a table in a database to read and change its records.
  • Explore different techniques you can use to add data to an Excel workbook.
  • Learn how to create charts from code using information in Excel or the result of a database query.
  • Find out how to get information from Word documents to create new documents or PowerPoint presentations.
  • See how you can automatically send an Outlook e-mail message while you’re working in Excel or Word.

To get the most out of VBA Solutions for Microsoft Office, you must understand basic programming concepts such as control structures, looping structures, and variables. You must also be familiar with creating simple procedures in any VBA host, such as Microsoft Access, Microsoft Excel, Microsoft PowerPoint, or Microsoft Word.


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


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

back to top

Your Instructor

Jan Fransen has been working to educate people in the best ways to use Microsoft products for more than 10 years. She's written both data-based and document-based applications for large and small companies, and has helped hundreds of Office users and developers get started on the right foot through public and onsite training classes. As a writer, Jan has developed training courseware, contributed to books on Microsoft Office, written white papers for publication on MSDN, and created samples designed to help developers get up to speed quickly on new Microsoft products and features.

back to top

About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac

Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$

Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy