Dummies.com
  • Print
  • Share
Excel 2007 VBA Programming For Dummies (1118050800) cover image

Excel 2007 VBA Programming For Dummies

ISBN: 978-1-118-05080-4
E-book
384 pages
February 2011
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: Introducing VBA 9

Chapter 1: What Is VBA? 11

Chapter 2: Jumping Right In 21

Part II: How VBA Works with Excel 33

Chapter 3: Working In the Visual Basic Editor 35

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 113

Chapter 9: Using VBA and Worksheet Functions 125

Chapter 10: Controlling Program Flow and Making Decisions 139

Chapter 11: Automatic Procedures and Events 157

Chapter 12: Error-Handling Techniques 177

Chapter 13: Bug Extermination Techniques 191

Chapter 14: VBA Programming Examples 203

Part IV: Communicating with Your Users 221

Chapter 15: Simple Dialog Boxes 223

Chapter 16: UserForm Basics 239

Chapter 17: Using UserForm Controls 255

Chapter 18: UserForm Techniques and Tricks 275

Chapter 19: Accessing Your Macros Through the User Interface 299

Part V: Putting It All Together 315

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

Chapter 21: Creating Excel Add-Ins 333

Part VI: The Part of Tens 345

Chapter 22: Ten VBA Questions (And Answers) 347

Chapter 23: (Almost) Ten Excel Resources 351

Index 355

  • Print
  • Share