Introduction 1
Part I: Getting Started with Excel VBA Programming 9
Chapter 1: What Is VBA? 11
Chapter 2: Jumping Right In 21
Part II: How VBA Works with Excel 31
Chapter 3: Working in the Visual Basic Editor 33
Chapter 4: Introducing the Excel Object Model 53
Chapter 5: VBA Sub and Function Procedures 67
Chapter 6: Using the Excel Macro Recorder 79
Part III: Programming Concepts 91
Chapter 7: Essential VBA Language Elements 93
Chapter 8: Working with Range Objects 115
Chapter 9: Using VBA and Worksheet Functions 129
Chapter 10: Controlling Program Flow and Making Decisions 143
Chapter 11: Automatic Procedures and Events 163
Chapter 12: Error-Handling Techniques 183
Chapter 13: Bug Extermination Techniques 197
Chapter 14: VBA Programming Examples 209
Part IV: Communicating with Your Users 231
Chapter 15: Simple Dialog Boxes 233
Chapter 16: UserForm Basics 249
Chapter 17: Using UserForm Controls 265
Chapter 18: UserForm Techniques and Tricks 283
Chapter 19: Accessing Your Macros through the User Interface 307
Part V: Putting It All Together 327
Chapter 20: Creating Worksheet Functions — and Living to Tell about It 329
Chapter 21: Creating Excel Add-Ins 347
Part VI: The Part of Tens 359
Chapter 22: Ten VBA Questions (and Answers) 361
Chapter 23: (Almost) Ten Excel Resources 365
Chapter 24: Ten VBA Do’s and Don’ts 369
Index 375