Excel 2007 VBA Programming For Dummies

Step-by-step instructions for creating VBA macros Harness the power of VBA and create custom Excel applications Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more. Discover how to Grasp essential programming concepts Use the Visual Basic Editor Navigate the new Excel user interface Communicate with your users Deal with errors and bugs

Step-by-step instructions for creating VBA macrosHarness the power of VBA and create custom Excel applicationsMake Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.Discover how to* Grasp essential programming concepts* Use the Visual Basic Editor* Navigate the new Excel user interface* Communicate with your users* Deal with errors and bugs

Introduction 1Part I: Introducing VBA 9Chapter 1: What Is VBA? 11Chapter 2: Jumping Right In 21Part II: How VBA Works with Excel 33Chapter 3: Working In the Visual Basic Editor 35Chapter 4: Introducing the Excel Object Model 53Chapter 5: VBA Sub and Function Procedures 67Chapter 6: Using the Excel Macro Recorder 79Part III: Programming Concepts 91Chapter 7: Essential VBA Language Elements 93Chapter 8: Working with Range Objects 113Chapter 9: Using VBA and Worksheet Functions 125Chapter 10: Controlling Program Flow and Making Decisions 139Chapter 11: Automatic Procedures and Events 157Chapter 12: Error-Handling Techniques 177Chapter 13: Bug Extermination Techniques 191Chapter 14: VBA Programming Examples 203Part IV: Communicating with Your Users 221Chapter 15: Simple Dialog Boxes 223Chapter 16: UserForm Basics 239Chapter 17: Using UserForm Controls 255Chapter 18: UserForm Techniques and Tricks 275Chapter 19: Accessing Your Macros Through the User Interface 299Part V: Putting It All Together 315Chapter 20: Creating Worksheet Functions and Living to Tell about It 317Chapter 21: Creating Excel Add-Ins 333Part VI: The Part of Tens 345Chapter 22: Ten VBA Questions (And Answers) 347Chapter 23: (Almost) Ten Excel Resources 351Index 355