0%

Book Description

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

  1. Cover
  2. Table of Contents
  3. Title Page
  4. Introduction
  5. Part I: Getting Started with Excel VBA Programming
    1. Chapter 1: What Is VBA?
    2. Chapter 2: Jumping Right In
  6. Part II: How VBA Works with Excel
    1. Chapter 3: Working in the Visual Basic Editor
    2. Chapter 4: Introducing the Excel Object Model
    3. Chapter 5: VBA Sub and Function Procedures
    4. Chapter 6: Using the Excel Macro Recorder
  7. Part III: Programming Concepts
    1. Chapter 7: Essential VBA Language Elements
    2. Chapter 8: Working with Range Objects
    3. Chapter 9: Using VBA and Worksheet Functions
    4. Chapter 10: Controlling Program Flow and Making Decisions
    5. Chapter 11: Automatic Procedures and Events
    6. Chapter 12: Error-Handling Techniques
    7. Chapter 13: Bug Extermination Techniques
    8. Chapter 14: VBA Programming Examples
  8. Part IV: Communicating with Your Users
    1. Chapter 15: Simple Dialog Boxes
    2. Chapter 16: UserForm Basics
    3. Chapter 17: Using UserForm Controls
    4. Chapter 18: UserForm Techniques and Tricks
    5. Chapter 19: Accessing Your Macros through the User Interface
  9. Part V: Putting It All Together
    1. Chapter 20: Creating Worksheet Functions - and Living to Tell about It
    2. Chapter 21: Creating Excel Add-Ins
  10. Part VI: The Part of Tens
    1. Chapter 22: Ten VBA Questions (and Answers)
    2. Chapter 23: (Almost) Ten Excel Resources
    3. Chapter 24: Ten VBA Do's and Don'ts
  11. Cheat Sheet