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