1. Chapter 1 Introduction

2. Chapter 2 Preliminaries

   1. What Is a Programming Language?

   2. Programming Style

3. The VBA Environment

   1. Chapter 3 The Visual Basic Editor, Part I

      1. The Project Window
      2. The Properties Window
      3. The Code Window
      4. The Immediate Window
      5. Arranging Windows
      6. Document Events

   2. Chapter 4 The Visual Basic Editor, Part II

      1. Navigating the IDE
      2. Getting Help
      3. Creating a Procedure
      4. Run Mode, Design Mode, and Break Mode
      5. Errors
      6. Debugging
      7. Macros

4. The VBA Programming Language

   1. Chapter 5 Variables, Data Types, and Constants

      1. Comments
      2. Line Continuation
      3. Constants
      4. Variables and Data Types
      5. VBA Operators

   2. Chapter 6 Functions and Subroutines

      1. Calling Functions
      2. Calling Subroutines
      3. Parameters and Arguments
      4. Exiting a Procedure
      5. Public and Private Procedures
      6. Referencing a Project

   3. Chapter 7 Built-in Functions and Statements

      1. The MsgBox Function
      2. The InputBox Function
      3. VBA String Functions
      4. Miscellaneous Functions and Statements

   4. Chapter 8 Control Statements

      1. The If… Then Statement
      2. The For Loop
      3. The For Each Loop
      4. The Do Loop
      5. The Select Case Statement
      6. A Final Note on VBA

5. Objects and Object Models

   1. Chapter 9 Object Models

      1. Objects, Properties, and Methods
      2. Collection Objects
      3. Object Model Hierarchies
      4. Object Model Syntax
      5. Object Variables

   2. Chapter 10 The Word Object Model

      1. The Word Object Model: A Perspective
      2. Word Enums
      3. The VBA Object Browser

   3. Chapter 11 The Application Object

      1. Properties and Methods
      2. The Options Object
      3. The Task Object
      4. The Template Object
      5. The Window Object
      6. The Pane Object
      7. The View Object
      8. The Zoom Object

   4. Chapter 12 The Document Object

      1. Properties That Return Collections
      2. Spelling-Related Properties and Methods
      3. The Documents Collection
      4. Adding, Opening, and Saving Documents
      5. Password-Related Properties
      6. Protection-Related Properties and Methods
      7. The Name Properties
      8. Printing-Related Methods
      9. Additional Members of the Document Object
      10. Children of the Document Object
      11. Example: Printing Document Headings
      12. Example: Finding Used Styles

   5. Chapter 13 The Section and HeaderFooter Objects

      1. Adding a New Section
      2. The PageSetup Object
      3. Properties of the Section Object
      4. The HeaderFooter Object

   6. Chapter 14 The Range and Selection Objects

      1. Comparing the Range and Selection Objects
      2. Range and Selection Variables
      3. Creating a Range or Selection Object
      4. Changing a Range Object
      5. Range and Selection Object Properties and Methods

   7. Chapter 15 The Find and Replace Objects

      1. Searching for Text
      2. Searching for Formatting
      3. The Replace Operation
      4. The Execute Method
      5. Example: Repeated Searching

   8. Chapter 16 The Table Object

      1. Formatting-Related Properties and Methods
      2. The Cell Method
      3. The Columns and Rows Properties
      4. The ConvertToText Method
      5. Sorting Methods
      6. The Split Method
      7. Example: Creating Tables from Word Lists
      8. Example: Closing Up a Table

   9. Chapter 17 The List Object

      1. List Types
      2. The List Object
      3. The ListTemplate Object and ListGalleries
      4. Example: Looking at Lists

   10. Chapter 18 Shortcut Key Bindings

       1. Finding a Key Binding
       2. Creating a Key Binding
       3. The KeyBinding Object

   11. Chapter 19 Built-in Dialog Objects

       1. The Show Method
       2. The Display and Execute Methods
       3. The DefaultTab Property
       4. The Type Property
       5. The Update Method
       6. Example: Printing Document Statistics

   12. Chapter 20 Custom Dialog Boxes

       1. What Is a UserForm Object?
       2. Example: Adding a Closing to a Letter
       3. Example: A Fax Cover Sheet
       4. Example: Quick Selection

   13. Chapter 21 Menus and Toolbars

       1. An Overview
       2. CustomizationContext
       3. The CommandBars Collection
       4. The CommandBar Object
       5. Command Bar Controls

6. Appendixes

   1. Appendix Programming Word from Another Application

      1. Setting a Reference to the Word Object Model
      2. Getting a Reference to the Word Application Object
      3. An Alternative Approach

   2. Appendix The Shape Object

      1. The Shape and InLineShape Objects
      2. Z-Order
      3. Creating InLineShapes
      4. Creating Shapes
      5. Examples
      6. WordArt

   3. Appendix Getting the Installed Printers

   4. Appendix High-Level and Low-Level Languages

      1. BASIC
      2. Visual Basic
      3. C and C++
      4. Visual C++
      5. Pascal
      6. FORTRAN
      7. COBOL
      8. Lisp

1. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal appearing on the cover of Writing Word Macros is a Beisa oryx (Oryx gazella beisa), a brownish-grey subspecies of East African antelope. The oryx is distinctively marked with black and white face and leg patterns; their white underbelly is outlined with a black stripe. The oryx is about the size of a deer (1.5-2.4 meters long), with slightly curved, parallel, ridged horns up to four feet long; these are used for defense in both sexes.

The Beisa oryx is located throughout eastern Africa, particularly Ethiopia, in short-grass steppes, semi-desert, and savannah habitats, feeding upon leaves, grasses, fruits, and other plant materials. They are gregarious, traveling in herds of a few dozen, and eating several times a day. Their enemies include large cats, such as leopards, lions, and cheetahs, as well as hyenas and human hunters. Their territory has dwindled due to excessive hunting. The Beisa oryx once appeared on one of a series of Ethiopian stamps celebrating the nation's wildlife. Nancy Kotary was the production editor and copyeditor for Writing Word Macros; Jeffrey Holcomb was the production editor coordinating the updates for the revised edition. Sheryl Avruch was the production manager. Kristine Simmons was the proofreader. Mary Anne Mayo, Jane Ellin, and Nancy Kotary provided quality control. Kimo Carter provided production support. Ruth Rautenberg wrote the index. Brenda Miller updated the index for the revised edition. Mike Sierra provided FrameMaker technical support.

Kathleen Wilson designed the cover of this book, using a 19th-century engraving from the Dover Pictorial Archive. The cover layout was produced with QuarkXPress 3.32 using the ITC Garamond font. Whenever possible, our books use RepKover™, a durable and flexible lay-flat binding. If the page count exceeds RepKover™'s limit, perfect binding is used.

The inside layout was designed by Nancy Priest and implemented in FrameMaker 5.5 by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book. The illustrations that appear in the book were created in Macromedia FreeHand 7 and Adobe Photoshop 4 by Robert Romano. This colophon was written by Nancy Kotary.