Excel VBA programming for dummies

Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- Obligatory Typographical Conventions Section -- Check Your Security Settings -- Foolish Assumptions -- Icons Used in This Book -- Sample Files Online -- Where to Go from Here -- Part 1 Getting Started with Excel VBA Programming -- Chapter 1 What Is VBA? -- Okay, So What Is VBA? -- What Can You Do with VBA? -- Inserting a bunch of text -- Automating a task you perform frequently -- Automating repetitive operations -- Creating a custom command -- Creating a custom button -- Developing new worksheet functions -- Creating custom add-ins for Excel -- Advantages and Disadvantages of VBA -- VBA advantages -- VBA disadvantages -- VBA in a Nutshell -- Excel Compatibility -- Chapter 2 Jumping Right In -- First Things First -- What You'll Be Doing -- Taking the First Steps -- Recording the Macro -- Testing the Macro -- Examining the Macro -- Modifying the Macro -- Saving Workbooks That Contain Macros -- Understanding Macro Security -- Revealing More about the NameAndTime Macro -- Part 2 How VBA Works with Excel -- Chapter 3 Working in the Visual Basic Editor -- What Is the Visual Basic Editor? -- Activating the VBE -- Understanding VBE components -- Working with the Project Window -- Adding a new VBA module -- Removing a VBA module -- Exporting and importing objects -- Working with a Code Window -- Minimizing and maximizing windows -- Creating a module -- Getting VBA code into a module -- Entering code directly -- Using the macro recorder -- Copying VBA code -- Customizing the VBA Environment -- Using the Editor tab -- Using the Editor Format tab -- Using the General tab -- Using the Docking tab -- Chapter 4 Introducing the Excel Object Model -- Excel Is an Object? -- Climbing Down the Object Hierarchy -- Wrapping Your Mind around Collections.