Mastering VBA for Microsoft Office 2013 (eBook)

Richard Mansfield is the author or coauthor of 45 books, including Visual Basic 6 Database Programming For Dummies, Office 2003 Application Development All-in-One Desk Reference For Dummies, How to Do Everything with Second Life, and Programming: A Beginner's Guide. He is the former editor of Compute! magazine. Overall, his books have sold more than half a million copies worldwide and have been translated into 12 languages.

Introduction xxix

Part 1 * Recording Macros and Getting Started with VBA
1

Chapter 1 * Recording and Running Macros in the Office
Applications 3

Chapter 2 * Getting Started with the Visual Basic Editor
31

Chapter 3 * Editing Recorded Macros 65

Chapter 4 * Creating Code from Scratch in the Visual Basic
Editor 87

Part 2 * Learning How to Work with VBA 107

Chapter 5 * Understanding the Essentials of VBA Syntax
109

Chapter 6 * Working with Variables, Constants, and
Enumerations 125

Chapter 7 * Using Array Variables 147

Chapter 8 * Finding the Objects, Methods, and Properties
You Need 171

Part 3 * Making Decisions and Using Loops and Functions
197

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 Dialog
Boxes 305

Chapter 13 * Getting User Input with Message Boxes and
Input 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 Classes
451

Chapter 17 * Debugging Your Code and Handling Errors
481

Chapter 18 * Building Well-Behaved Code 511

Chapter 19 * Securing Your Code with VBA's Security
Features 525

Part 6 * Programming the Offi ce Applications
547

Chapter 20 * Understanding the Word Object Model and Key
Objects 549

Chapter 21 * Working with Widely Used Objects in Word
877

Chapter 22 * Understanding the Excel Object Model and Key
Objects 615

Chapter 23 * Working with Widely Used Objects in Excel
641

Chapter 24 * Understanding the PowerPoint Object Model and
Key Objects 879

Chapter 25 * Working with Shapes and Running Slide Shows
677

Chapter 26 * Understanding the Outlook Object Model and
Key Objects 697

Chapter 27 * Working with Events in Outlook 719

Chapter 28 * Understanding the Access Object Model and Key
Objects 739

Chapter 29 * Manipulating the Data in an Access Database
via VBA 763

Chapter 30 * Accessing One Application from Another
Application 785

Chapter 31 * Programming the Offi ce 2013 Ribbon 813

Appendix * Th e Bottom Line 847

Index 889