Contents at a Glance

Introduction 1

Part 1: Introducing VBA 9

Chapter 1:What Is VBA? 11

Chapter 2: Jumping Right In 21

Part 11: How VBA Works with Excel 31

Chapter 3: Introducing the Visual Basic Editor 33

Chapter 4: Introducing the Excel Object Model 51

Chapter 5: VBA Sub and Function Procedures 63

Chapter 6: Using the Excel Macro Recorder 75

Part 111: Programming Concepts 87

Chapter 7: Essential VBA Language Elements 89

Chapter 8: Working with Range Objects 107

Chapter 9: Using VBA and Worksheet Functions 119

Chapter 10: Controlling Program Flow and Making Decisions 133

Chapter 11: Automatic Procedures and Events 151

Chapter 12: Error-Handling Techniques 171

Chapter 13: Bug Extermination Techniques 185

Chapter 14: VBA Programming Examples 195

Part 1V: Developing Custom Dialog Boxes 213

Chapter 15: Custom Dialog Box Alternatives 215

Chapter 16: Custom Dialog Box Basics 231

Chapter 17: Using Dialog Box Controls 247

Chapter 18: UserForm Techniques and Tricks 265

Part V: Creating Custom Toolbars and Menus 287

Chapter 19: Customizing the Excel Toolbars 289

Chapter 20: When the Normal Excel Menus Aren't Good Enough 307

Part V1: Putting 1t All Together 323

Chapter 21: Creating Worksheet Functions — and Living to Tell about It 325

Chapter 22: Creating Excel Add-Ins 339

Chapter 23: Interacting with Other Office Applications 351

Part VII: The Part of Tens 363

Chapter 24: Ten VBA Questions (And Answers) 365

Chapter 25: (Almost) Ten Excel Resources 369

Index 373

0 0

Post a comment