Excel VBA Programming For Dummies

Introduction 1

Part 1: Starting Excel VBA Programming 7

Chapter 1: Getting to Know VBA 9

Chapter 2: Building Simple Macros 17

Part 2: Employing VBA with Excel 29

Chapter 3: Working in the Visual Basic Editor 31

Chapter 4: Introducing the Excel Object Model 51

Chapter 5: VBA Sub and Function Procedures 67

Chapter 6: Using the Excel Macro Recorder 83

Part 3: Programming Concepts 97

Chapter 7: Essential VBA Language Elements 99

Chapter 8: Working with Range Objects 119

Chapter 9: Using VBA and Worksheet Functions 135

Chapter 10: Controlling Program Flow and Making Decisions 151

Chapter 11: Automatic Procedures and Events 171

Chapter 12: Error-Handling Techniques 193

Chapter 13: Bug Extermination Techniques 205

Chapter 14: VBA Programming Examples 219

Part 4: Communicating with Your Users 243

Chapter 15: Simple Dialog Boxes 245

Chapter 16: UserForm Basics 263

Chapter 17: Using UserForm Controls 281

Chapter 18: UserForm Techniques and Tricks 301

Chapter 19: Accessing Your Macros through the User Interface 329

Part 5: Putting It All Together 343

Chapter 20: Creating Worksheet Functions 345

Chapter 21: Creating Excel Add-Ins 365

Part 6: The Part of Tens 377

Chapter 22: Ten Handy Visual Basic Editor Tips 379

Chapter 23: Resources for VBA Help 389

Chapter 24: Ten VBA Do's and Don'ts 395

Index 401

Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.

• Aplicações de negócios

Excel visual basic for applications; visual basic for applications in excel; what is excel vba?; vba programming guide; vba programming text; vba programming basics; excel programming basics; excel programming; vba basics; vba fundamentals