Excel VBA Programming For Dummies

By John Walkenbach

Book Overview

Take your Excel skills to the next level with VBA programming Now that you've mastered Excel basics, it's time to move to the next level--creating your own, customized Excel 2010 solutions using Visual Basic for Applications (VBA). The new edition of this non-threatening guide is your key to getting there. Using step-by-step instruction and the accessible, friendly 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. The book's Web site provides all the programming examples from the book. Introduces you to a new range of Excel 2010 options Shows you how to use Visual Basic for Applications (VBA) to program your own custom Excel applications or to automate functions Explains how to create VBA macros, program, handle errors, debug, and more Covers Visual Basic Editor tools and functions; working with range objects; controlling program flow; and the easiest ways to create custom dialog boxes, toolbars, and menus Includes a companion Web site with all the sample programs from the book Create your own, custom Excel programs with this information-packed guide Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

• Format: Paperback
• Language: English
• ISBN: 0470503696
• ISBN13: 9780470503690
• Release Date: May 2010
• Publisher: For Dummies
• Length: 388 Pages
• Weight: 1.41 lbs.
• Dimensions: 0.8" x 7.0" x 9.9"

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...