Excel Vba Programming for Dummies

by Walkenbach, John

• ISBN13: 9781118490372
• ISBN10: 1118490371
• Edition: 3rd
• Format: Paperback
• Copyright: 2013-02-25
• Publisher: For Dummies

Summary

Harness the power of VBA to create custom Excel applications Showing you how to take advantage of the features in the new Excel 2013, John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized Excel 2013 solutions using Visual Basic for Applications (VBA). Using step-by-step instruction and the easy-to-understand For Dummies style, this practical book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more. Introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor Provides an overview of the essential elements and concepts for programming with Excel Shares techniques for handling errors, debugging, working with range objects, controlling flow, and much more Zeroes in on creating custom dialog boxes, toolbars, and menus With Excel VBA Programming For Dummies, 3rd Edition , you will be creating Excel applications custom fit to their unique needs in no time.

Author Biography

John Walkenbach, known to his fans as Mr. Spreadsheet, has written some 50 books and around 300 articles on computer topics, predominantly Excel. He created the award-winning Power Utility Pak and several other versatile Excel add-ons. John maintains the Spreadsheet Page at http://spreadsheetpage.com.

Table of Contents

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