Mastering VBA for Microsoft Office 2013

Introduction xxix Part 1 * Recording Macros and Getting Started with VBA1 Chapter 1 * Recording and Running Macros in the OfficeApplications 3 Chapter 2 * Getting Started with the Visual Basic Editor31 Chapter 3 * Editing Recorded Macros 65 Chapter 4 * Creating Code from Scratch in the Visual BasicEditor 87 Part 2 * Learning How to Work with VBA 107 Chapter 5 * Understanding the Essentials of VBA Syntax109 Chapter 6 * Working with Variables, Constants, andEnumerations 125 Chapter 7 * Using Array Variables 147 Chapter 8 * Finding the Objects, Methods, and PropertiesYou Need 171 Part 3 * Making Decisions and Using Loops and Functions197 Chapter 9 * Using Built-in Functions 199 Chapter 10 * Creating Your Own Functions 235 Chapter 11 * Making Decisions in Your Code 255 Chapter 12 * Using Loops to Repeat Actions 277 Part 4 * Using Message Boxes, Input Boxes, and DialogBoxes 305 Chapter 13 * Getting User Input with Message Boxes andInput Boxes 307 Chapter 14 * Creating Simple Custom Dialog Boxes 329 Chapter 15 * Creating Complex Forms 399 Part 5 * Creating Eff ective Code 449 Chapter 16 * Building Modular Code and Using Classes451 Chapter 17 * Debugging Your Code and Handling Errors481 Chapter 18 * Building Well-Behaved Code 511 Chapter 19 * Securing Your Code with VBA's SecurityFeatures 525 Part 6 * Programming the Offi ce Applications547 Chapter 20 * Understanding the Word Object Model and KeyObjects 549 Chapter 21 * Working with Widely Used Objects in Word877 Chapter 22 * Understanding the Excel Object Model and KeyObjects 615 Chapter 23 * Working with Widely Used Objects in Excel641 Chapter 24 * Understanding the PowerPoint Object Model andKey Objects 879 Chapter 25 * Working with Shapes and Running Slide Shows677 Chapter 26 * Understanding the Outlook Object Model andKey Objects 697 Chapter 27 * Working with Events in Outlook 719 Chapter 28 * Understanding the Access Object Model and KeyObjects 739 Chapter 29 * Manipulating the Data in an Access Databasevia VBA 763 Chapter 30 * Accessing One Application from AnotherApplication 785 Chapter 31 * Programming the Offi ce 2013 Ribbon 813 Appendix * Th e Bottom Line 847 Index 889