Intro -- Title Page -- Copyright -- About the Authors -- About the Technical Editor -- Credits -- Introduction -- Topics Covered -- What You Need to Know -- What You Need to Have -- Conventions in This Book -- What the Icons Mean -- How This Book Is Organized -- About This Book's Website -- About the Power Utility Pak Offer -- Part I: Introduction to Excel VBA -- Chapter 1: Essentials of Spreadsheet Application Development -- What Is a Spreadsheet Application? -- Steps for Application Development -- Determining User Needs -- Planning an Application That Meets User Needs -- Determining the Most Appropriate User Interface -- Concerning Yourself with the End User -- Other Development Issues -- Chapter 2: Introducing Visual Basic for Applications -- Getting a Head Start with the Macro Recorder -- Working with the Visual Basic Editor -- VBA Fundamentals -- Deep Dive: Working with Range Objects -- Essential Concepts to Remember -- Don't Panic - You Are Not Alone -- Chapter 3: VBA Programming Fundamentals -- VBA Language Elements: An Overview -- Comments -- Variables, Data Types, and Constants -- Assignment Statements -- Arrays -- Object Variables -- User-Defined Data Types -- Built-In Functions -- Manipulating Objects and Collections -- Controlling Code Execution -- Chapter 4: Working with VBA Sub Procedures -- About Procedures -- Executing Sub Procedures -- Passing Arguments to Procedures -- Error-Handling Techniques -- A Realistic Example That Uses Sub Procedures -- Chapter 5: Creating Function Procedures -- Sub Procedures versus Function Procedures -- Why Create Custom Functions? -- An Introductory Function Example -- Function Procedures -- Function Arguments -- Function Examples -- Emulating Excel's SUM Function -- Extended Date Functions -- Debugging Functions -- Dealing with the Insert Function Dialog Box.
