Microsoft Office System

I Getting Started with VBA

1 Creating and Running Recorded Macros 3

2 Writing Your Own Macros 15

3 Understanding Program Variables 33

4 Building VBA Expressions 53

5 Working with Objects 71

6 Controlling Your VBA Code 91

II Putting VBA to Work

7 Programming Word 115

8 Programming Excel 139

9 Programming PowerPoint 165

10 Programming Access Databases 189

11 Programming Outlook Email 213

III Getting the Most Out of VBA

12 Creating Custom VBA Dialog Boxes 237

13 Customizing the Office 2007 Ribbon 263

14 VBA Tips and Techniques 299

15 Trapping Program Errors 323

16 Debugging VBA Procedures 337

IV Appendixes

A VBA Statements 355

B VBA Functions 361

Index 371

Paul McFedries

0 0

Post a comment