Brilliant VBA for Microsoft Office 2007

Paul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams).

Introduction


I Getting Started with VBA

1 Creating and Running Recorded Macros


2 Writing Your Own Macros


3 Understanding Program Variables


4 Building VBA Expressions


5 Working with Objects


6 Controlling Your VBA Code


II Putting VBA to Work

7 Programming Word


8 Programming Excel


9 Programming PowerPoint


10 Programming Access Databases


11 Programming Outlook Email


III Getting the Most Out of VBA

12 Creating Custom VBA Dialog Boxes


13 Customizing the Office 2007 Ribbon


14 VBA Tips and Techniques


15 Trapping Program Errors


16 Debugging VBA Procedures


IV Appendixes

A VBA Statements


B VBA Functions


Index