Thank you for visiting us. We are currently updating our shopping cart and regret to advise that it will be unavailable until September 1, 2014. We apologise for any inconvenience and look forward to serving you again.

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

Excel VBA Programming For Dummies, 3rd Edition

ISBN: 978-1-118-49038-9
E-book
408 pages
February 2013
US $19.99 Purchase This E-book

This price is valid for United States. Change location to view local pricing and availability.

How to read this e-book on:
Adobe e-books are read using Adobe Digital Editions. Install Adobe Digital Editions on your PC in order to read or transfer your 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