Excel VBA Programming For Dummies, 3rd Edition

Take control of your spreadsheets and use VBA to create your own custom Excel applications

Author and Excel guru 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 spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling 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 2013 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, including using VBA to customize your applications and automate functions
• 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

Add a personal touch to your spreadsheets and present your data the way you want with Excel VBA Programming For Dummies, 3rd Edition.

Table of Contents

Part I: Getting Started with Excel VBA Programming
Chapter 1: What Is VBA?
Chapter 2: Jumping Right In

Part II: How VBA Works with Excel
Chapter 3: Working in the Visual Basic Editor
Chapter 4: Introducing the Excel Object Model
Chapter 5: VBA Sub and Function Procedures
Chapter 6: Using the Excel Macro Recorder

Part III: Programming Concepts
Chapter 7: Essential VBA Language Elements
Chapter 8: Working with Range Objects
Chapter 9: Using VBA and Worksheet Functions
Chapter 10: Controlling Program Flow and Making Decisions
Chapter 11: Automatic Procedures and Events
Chapter 12: Error-Handling Techniques
Chapter 13: Bug Extermination Techniques
Chapter 14: VBA Programming Examples

Part IV: Communicating with Your Users
Chapter 15: Simple Dialog Boxes
Chapter 16: UserForm Basics
Chapter 17: Using UserForm Controls
Chapter 18: UserForm Techniques and Tricks
Chapter 19: Accessing Your Macros through the User Interface

Part V: Putting It All Together
Chapter 20: Creating Worksheet Functions—and Living to Tell about It
Chapter 21: Creating Excel Add-Ins

Part VI: The Part of Tens
Chapter 22: Ten VBA Questions (and Answers)
Chapter 23: (Almost) Ten Excel Resources
Chapter 24: Ten VBA Do’s and Don’ts