Table of Contents

What is VBA, and what can you do with it?; recording and running macros in the Microsoft Office applications; using the Visual Basic editor; editing recorded macros; the essentials of VBA syntax. working with variables and constants; using arrays; finding the objects you need; using and creating functions; creating procedures; using message boxes and input boxes; using loops to repeat actions; making decisions in your code; object models; creating simple custom dialog boxes; creating complex dialog boxes; building modular code; debugging your code; building well-behaved procedures; using VBA's security features.

About the Author

Guy Hart-Davis is the author of Word 2000 Developer's Handbook and Word 97 Macro & VBA Handbook, both published by Sybex. He uses VBA for fun and profit, and is an occasional contributor to the Visual Basic Programmer's Journal.