Mastering VBA Book

Ch. 1	Recording and running macros in the Microsoft Office applications	3
Ch. 2	Getting started with the Visual Basic Editor	29
Ch. 3	Editing recorded macros	55
Ch. 4	Creating code from scratch in the Visual Basic Editor	73
Ch. 5	Understanding the essentials of VBA syntax	91
Ch. 6	Working with variables, constants, and enumerations	101
Ch. 7	Using array variables	117
Ch. 8	Finding the objects, methods, and properties you need	135
Ch. 9	Using functions	155
Ch. 10	Creating your own functions	185
Ch. 11	Making decisions in your code	199
Ch. 12	Using loops to repeat actions	219
Ch. 13	Getting user input with message boxes and input boxes	245
Ch. 14	Creating simple custom dialog boxes	263
Ch. 15	Creating complex dialog boxes	319
Ch. 16	Building modular code and using classes	365
Ch. 17	Debugging your code and handling errors	387
Ch. 18	Building well-behaved code	411
Ch. 19	Securing your code with VBA's security features	423
Ch. 20	Understanding the Word object model and key objects	441
Ch. 21	Working with widely used objects in word	465
Ch. 22	Understanding the Excel object model and key objects	493
Ch. 23	Working with widely used objects in Excel	517
Ch. 24	Understanding the PowerPoint object model and key objects	529
Ch. 25	Working with shapes and running slide shows	549
Ch. 26	Understanding the Outlook object model and key objects	567
Ch. 27	Working with events in Outlook	585
Ch. 28	Understanding the Access object model and key objects	599
Ch. 29	Manipulating the data in an Access Database via VBA	619
Ch. 30	Accessing one application from another application	635