VBA Training: VBA for Office XP and 2003

VBA Training Outline

• 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 VBA 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 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?
• 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
• Using the Macro Recorder: PowerPoint
• Working with Active Objects
• Active Properties in Office
• Excel’s Active and Selection Properties
• Word’s Active and Selection Properties
• The Access Screen Object
• Using Another Product’s Features with Automation
• Expanding Your Horizons Using Automation
• Getting to the Object Model
• Working With an Existing Instance
• Working with Data Using ADO
• Introducing ActiveX Data Objects
• Working with Data in Recordsets
• Moving Through a Recordset
• Creating a Recordset Based on a SQL String
• Adding a Recordset to a Worksheet
• How and When to Use DAO
• Techniques with VBA Variables
• Scope, Lifetime, and Precedence
• Passing by Value and by Reference
• Optional Arguments
• 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
• Working with the ADO Command Object
• Adding an Item to Outlook
• Adding Content to Word and PowerPoint
• Adding Text to a Word Document
• Adding Content to PowerPoint
• Charting Your Data
• Excel’s Chart Object
• Creating a Chart
• Creating an Excel Chart from Access
• Pasting Excel Charts Into Other Documents
• Giving Your Solutions to Others
• Sharing the Wealth
• Using Custom Toolbars
• Office Templates and Add-Ins
• Securing Your Code
• Using the Developer Edition to Deploy Solutions
• Conclusion