Writing Excel Macros with VBA, 2nd Edition

Table of Contents

1. A Note Regarding Supplemental Files
2. Preface
   1. Preface to the Second Edition
   2. The Book’s Audience
   3. Organization of This Book
   4. The Book’s Text and Sample Code
   5. About the Code
   6. Conventions in this Book
   7. Obtaining the Sample Programs
   8. How to Contact Us
   9. Acknowledgments
3. 1. Introduction
   1. 1.1. Selecting Special Cells
   2. 1.2. Setting a Chart’s Data Point Labels
   3. 1.3. Topics in Learning Excel Programming
4. I. The VBA Environment
   1. 2. Preliminaries
      1. 2.1. What Is a Programming Language?
      2. 2.2. Programming Style
         1. 2.2.1. Comments
         2. 2.2.2. Readability
         3. 2.2.3. Modularity
   2. 3. The Visual Basic Editor, Part I
      1. 3.1. The Project Window
         1. 3.1.1. Project Names
         2. 3.1.2. Project Contents
            1. 3.1.2.1. The ThisWorkbook object
            2. 3.1.2.2. Sheet objects
            3. 3.1.2.3. Standard modules
            4. 3.1.2.4. Class modules
            5. 3.1.2.5. UserForm objects
      2. 3.2. The Properties Window
      3. 3.3. The Code Window
         1. 3.3.1. Procedure and Full-Module Views
         2. 3.3.2. The Object and Procedure List Boxes
            1. 3.3.2.1. A workbook or sheet object
            2. 3.3.2.2. A standard module
            3. 3.3.2.3. A UserForm object
      4. 3.4. The Immediate Window
      5. 3.5. Arranging Windows
         1. 3.5.1. Docking
   3. 4. The Visual Basic Editor, Part II
      1. 4.1. Navigating the IDE
         1. 4.1.1. General Navigation
            1. 4.1.1.1. Navigating the code window at design time
            2. 4.1.1.2. Tracing code
            3. 4.1.1.3. Bookmarks
      2. 4.2. Getting Help
      3. 4.3. Creating a Procedure
      4. 4.4. Run Time, Design Time, and Break Mode
      5. 4.5. Errors
         1. 4.5.1. Design-Time Errors
         2. 4.5.2. Compile-Time Errors
         3. 4.5.3. Run-Time Errors
         4. 4.5.4. Logical Errors
      6. 4.6. Debugging
         1. 4.6.1. Tracing
            1. 4.6.1.1. Stepping into
            2. 4.6.1.2. Step Over ...