+612 9045 4394
Excel VBA Programming for Dummies, 3rd Edition : For Dummies - John Walkenbach

Excel VBA Programming for Dummies, 3rd Edition

For Dummies

Sorry, the book that you are looking for is not available right now.

We did a search for other books with a similar title, however there were no matches. You can try selecting from a similar category, click on the author's name, or use the search box above to find your book.

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.



by PowerReviews

(based on 1 review)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 1 customer

Displaying review 1

Back to top


A useful easy read


from Brisbane, AU

About Me Everyday Reader

Verified Buyer


  • Easy To Read
  • Informative
  • Well Written


    Best Uses

    • Reference

    An easy to use reference for an engineer who has not coded for a few years. Easy to get going.

    Displaying review 1

    Back to top

    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

    ISBN: 9781118490372
    ISBN-10: 1118490371
    Series: For Dummies
    Audience: General
    Format: Paperback
    Language: English
    Number Of Pages: 408
    Published: 5th March 2013
    Country of Publication: US
    Dimensions (cm): 23.5 x 18.42  x 2.54
    Weight (kg): 0.56
    Edition Number: 1