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

Excel 2007 VBA Programming For Dummies

ISBN: 978-0-470-04674-6
Paperback
388 pages
February 2007
US $29.99 Add to Cart
Other Available Formats: 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

Buy Both and Save 25%!

+ Buy Excel 2007 VBA Programming For Dummies (List Price: US $29.99)
with Excel 2010 For Dummies Quick Reference (List Price = US $18.99)
Total List Price: US $48.98
Discounted Price: US $36.73
You Save: US $12.25 Add BOTH to Cart
Cannot be combined with any other offers. Learn more.
  • Print
  • Share