Quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft's Visual Basic for Applications (VBA) using the in-depth instructions in "Mastering VBA for Microsoft Office 2007," Jump right into the basics of recording and running macros with Office's built-in Macro Recorder, before you move quickly to the essentials of VBA syntax, using loops and functions, building effective code, and programming in Microsoft applications. Find page after page of easy-to-follow and fully up-to-date practical examples from Word, Excel, Outlook, PowerPoint, and Access.
Part 1. Recording Macros and Getting Started with VBA.
- Chapter 1. Recording and Running Macros in the Office Applications.
- Chapter 2. Getting Started with the Visual Basic Editor.
- Chapter 3. Editing Recorded Macros.
- Chapter 4. Creating Code from Scratch in the Visual Basic Editor.
Part 2. Learning How to Work with VBA.
- Chapter 5. Understanding the Essentials of VBA Syntax.
- Chapter 6. Working with Variables, Constants, and Enumerations.
- Chapter 7. Using Array Variables.
- Chapter 8. Finding the Objects, Methods, and Properties You Need.
Part 3. Making Decisions and Using Loops and Functions.
- Chapter 9. Using Functions.
- Chapter 10. Creating Your Own Functions.
- Chapter 11. Making Decisions in Your Code.
- Chapter 12. Using Loops to Repeat Actions.
Part 4. Using Message Boxes, Input Boxes, and Dialog Boxes.
- Chapter 13. Getting User Input with Message Boxes and Input Boxes.
- Chapter 14. Creating Simple Custom Dialog Boxes.
- Chapter 15. Creating Complex Dialog Boxes.
Part 5. Creating Effective Code.
- Chapter 16. Building Modular Code and Using Classes.
- Chapter 17. Debugging Your Code and Handling Errors.
- Chapter 18. Building Well–Behaved Code.
- Chapter 19. Securing Your Code with VBA′s Security Features.
Part 6. Programming the Office Applications.
- Chapter 20. Understanding the Word Object Model and Key Objects.
- Chapter 21. Working with Widely Used Objects in Word.
- Chapter 22. Understanding the Excel Object Model and Key Objects.
- Chapter 23. Working with Widely Used Objects in Excel.
- Chapter 24. Understanding the PowerPoint Object Model and Key Objects.
etc.
Glossary.