for dummies store - a Wiley Brand
  • Print
  • Share
Excel VBA Programming For Dummies, 4th Edition (1119077397) cover image

Excel VBA Programming For Dummies, 4th Edition

ISBN: 978-1-119-07739-8
Paperback
408 pages
October 2015
This title is out-of-print and not currently available for purchase from this site.

Introduction 1

Part I: Getting Started with Excel VBA Programming 7

Chapter 1: What Is VBA? 9

Chapter 2: Jumping Right In 19

Part II: How VBA Works 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 65

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 131

Chapter 10: Controlling Program Flow and Making Decisions 145

Chapter 11: Automatic Procedures and Events 165

Chapter 12: Error‐Handling Techniques 187

Chapter 13: Bug Extermination Techniques 201

Chapter 14: VBA Programming Examples 215

Part IV: Communicating with Your Users 237

Chapter 15: Simple Dialog Boxes 239

Chapter 16: UserForm Basics 257

Chapter 17: Using UserForm Controls 275

Chapter 18: UserForm Techniques and Tricks 295

Chapter 19: Accessing Your Macros through the User Interface 321

Part V: Putting It All Together 333

Chapter 20: Creating Worksheet Functions — and Living to Tell about It 335

Chapter 21: Creating Excel Add-Ins 353

Part VI: The Part of Tens 365

Chapter 22: Ten VBA Questions (and Answers) 367

Chapter 23: (Almost) Ten Excel Resources 371

Chapter 24: Ten VBA Do’s and Don’ts 375

Index 381

  • Print
  • Share