Dummies.com
  • Print
  • Share
Excel VBA Programming For Dummies, 3rd Edition (1118490371) cover image

Excel VBA Programming For Dummies, 3rd Edition

ISBN: 978-1-118-49037-2
Paperback
408 pages
February 2013
US $29.99 Add to Cart
View Previous Edition of This Title
Other Available Formats: E-book
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

  • Print
  • Share