Excel 2007 VBA Programming for Dummies

by John Walkenbach and Jan Karel Pieterse

Step-by-step instructions for creating VBA macros

Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus,...

• Format: Paperback
• Language: English
• ISBN: 0470046740
• ISBN13: 9780470046746
• Release Date: February 2007
• Publisher: For Dummies
• Length: 384 Pages
• Weight: 2.09 lbs.
• Dimensions: 0.8" x 7.4" x 9.3"

Customer Reviews

Great Book

Got the book a couple of weeks ago and am about 350 pages into it. Although I have only scratched the surface, I've been able to put together a couple of macros that did exactly what I was asked to accomplish. Great Book.

Very good reference for VBA Beginners

I have this book for more than two months now and I found it very useful especially on my first VBA project. I have a weekly report and I used to do this manually and often get errors because I have to cross reference values in one big spreadsheet with multiple tabs. Not until I got this book and read the basics and go to specific chapters where I need help. I felt so accomplished after I finished the whole macro. What took me 30 minutes to do manual referencing and typing now only takes less than two minutes including sending it through email. This book is very easy to understand especially for those who know Excel and would like to expand their skills in VBA. Mr Spreadsheet has provided good example files to help us better understand VBA. His approach is basic enough for those who doesn't have any experience in creating macros. By the way if your CD doesn't have the source files or example file go to http://www.wiley.com/WileyCDA/Section/id-302036.html and select "All Wiley Products" or call Technical Support. Type your request for the e-source files and they will get back to you really fast with a link of the FTP site for the files. Don't bother to call customer support because they will try to sell you the e-book even though you already have the book. It might be a hassle but its all worth it.

Awesome Resource...

This is - by far - the most valuable VBA tool I've purchased. I generally have a hard time reading books about programming because they are either 1) way above my head, 2) don't provide "real-life" examples of when you would want to use the code, or 3) just plain boring. Not with this book... It teaches you how to build tools - like progress indicators, advanced userforms, and general utilities. I've been able to take a little bit from each chapter and create stellar spreadsheet applications. This book has saved me hours... if I can't figure out how to write a block of code, I don't spend time searching Google - I go straight to the book. Best Reason: it comes with a CD full of macro examples that mirror the chapter concepts. I was able to read the chapter, then go to the computer and try it out (with the code already written out for me). I picked up new concepts much faster than just reading it on my own. Excellent for Excel 2003 or 2007.

5 stars in spite of the misleading title

This is a GREAT introduction to ALL aspects of Excel and VBA. Most people who need this book come into VBA from other experiences and have rarely taken classes in VBA and they need a readable reference that can bring them up to speed on the parts they don't understand yet. Used this way the book is simply outstanding and most users probably don't need anything more than this book, but I'm not one of those people. I purchased "Professional Excel Development" by Bullen, Bovey, and Green at the same time and was awestruck at the depth of their knowledge and their passion for making Excel the only development tool your company will ever need. In short they are absolutely insane in a very knowledgeable and useful way. The biggest problem with "Professional Excel Development" is that readers are expected to know a LOT more about Excel and VBA than average and Walkenbach nicely addresses that issue. He's also a lot more readable than the other authors and so can be used in conjunction with them to clarify the points that they are making. Regardless of how you use this book, it is a very good for just about any level of VBA developer and firmly earns the 5 star rating.

A complete guide

If you'd like to have a reference where you could look for to solve doubts or understand the way the things work in Excel, this the right book.