Excel VBA Programming for Dummies

By John Walkenbach

Book Overview

Take your data analysis and Excel programming skills to new heights In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). This 4th edition of Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, you'll get the lowdown on the essential elements and concepts for programming with Excel, discover techniques for handling errors and exterminating bugs, working with range objects, controlling program flow, and much more. With the release of Microsoft Office 2016, Excel will see changes in its operating system, and this fun, hands-on guide will make it easier than ever to harness the power of Visual Basic for Applications and create custom applications and macros on the world's most popular spreadsheet tool. Packed with friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, you'll be creating Excel applications custom-fit to your unique needs in no time at all Provides step-by-step instructions for creating VBA macros to maximize productivity Helps to increase efficiency by demonstrating how to customize your applications so they look and work the way you want Fully updated for Excel 2016 All sample programs, VBA code, and worksheets are available at dummies.com If you're a beginning to intermediate VBA programmer looking to get up to speed on creating customized solutions with Excel applications, Excel VBA Programming For Dummies, 4th Edition makes it easier.

• Format: Paperback
• Language: English
• ISBN: 1119077397
• ISBN13: 9781119077398
• Release Date: October 2015
• Publisher: For Dummies
• Length: 408 Pages
• Weight: 1.25 lbs.
• Dimensions: 0.8" x 7.3" x 9.2"

Customer Reviews

This is the place to start with Excel VBA

Plenty of fellow office workers have all come upon the same plight I did not too long ago. We're going along with our busy non-programming related work when all of a sudden *bam!* the boss decides we are the perfect candidates to either implement a new software solution or simplify/refine an existing one. I'd dabbled in C++ and Liberty Basic for my own personal use before, but had absolutely no experience whatsoever working...

Worth the money

I bought this book because of good reviews, and was quite pleased. I have some of a background in programming (decent at PERL, a tiny bit of visual basic), but had never done it in excel. I wanted to learn VBA for excel to automate my data analysis for a psychology experiment I am running. I knew that the actual program I would need to write would be fairly simple (just some contingent branching that averages response times...

Quick, Accurate, Not Just For Dummies - A Trusted Author

I needed to quickly do a macro for a large Excel workbook. Although I have programmed off and on for thirty years, I have done little with VBA. One night with this book was all that it took to learn the basics; and I completed the project the following day with only brief use of one other VBA reference book. As noted by another, Wallenbach is the best-known author of books on VBA for Excel and writes with a pleasant style...

3 Good Reasons To Buy This Book

When all is said and done, John Walkenbach only has three things going for him: One, he really knows what he is talking about. While this is a For Dummies book, and doesn't go down really into the Power Programming (that's another of his books) level, they couldn't have gotten a more knowledgeable person to write it. You can take what he says in the book (or on the books companion web site just in case a typo made it through...