2007 Microsoft® Office System Inside Out

Chapter 31. VBA Primer

When and Why to Use VBA

Introduction to the VBA Language and Code Structure

Understanding and Using the Visual Basic Editor

Writing, Editing, and Sharing Simple Macros

Using VBA to Save Time on Document Production and Troubleshooting

Introduction to Using Events

Creating UserForms (Dialog Boxes)

Next Steps for Working with Automation in Microsoft Office

If you have any concerns about venturing into this chapter, take a deep breath and relax. You’ll be perfectly comfortable here. This is the first thorough primer on Microsoft Visual Basic for Applications (VBA) written for advanced Microsoft Office users, and not for programmers.

I’m not a programmer, so I won’t treat you like one. The fact is that you don’t have to be a programmer ...