Your Visual Basic for Applications for Microsoft Office Instructor

VBA for Microsoft Office CD-ROM 1

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

VBA for Microsoft Office CD-ROM 2

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

VBA for Microsoft Office CD-ROM 3

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?

VBA for Microsoft Office CD-ROM 4

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

VBA for Microsoft Office CD-ROM 5

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 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?

Check out the complete list of AppDev Training Videos