Excel VBA Programming for Dummies: Third Edition

For non Excel VBA beginners like myself, this book is a very good starting point. John covers all of the basics with clear, concise explanations and then follows up with code snippets and valuable real world advice. I would recommend that beginners like me thoroughly read the first 2 x chapters which explain the VBA editior, Functions, Procedures...etc before you dive in and start coding. In particular, have a good look at Variables before you start. You will probably save yourself some time and grief in the long run. I personally found the chapter on Controlling Program flow (Chap 10) invaluable after trying for some time to loop through a range of cells without success. Within half an hour or reading this chapter I was able to correct the code I had written to enable looping through and converting a range of 10 figure Grid References to 6 figure Grid References and then output the new values onto the active spreadsheet. If you are from Australia like I am, you won't regret paying the extra few dollars. I thoroughly recommend this book if you are a VBE newbie like myself!

Good book. Fun and easy to read. Exercises are easy to do, and all you need is Excel. No other sw needed. This book gives you a starting familiarity with Excel VBA.But, it is very basic. You'll need to go beyond this book if you are going to write actual real life VB applications.

Pros:Easy to read.Great for beginners.Easy to navigate (table of contents/index easy to understand).Cons:It is good for beginners, for the more advanced processes it is not all that helpful.Dumbs it down alot and makes it seem somewhat childish for people who already understand how excel/VBA work.Overall, it is a good product. I was hoping it would be more in depth but it will get the job done. It gives you the basic tools you need to code in excel VBA, and helps the user understand how it all works.

This book is a great intro to not only VBA, but to coding in general. The author really does a great job of teaching someone who knows no code to become completely self-sufficient in codind in VBA. The examples in the book are great and the god-awful jokes make the book a little more fun. The worksheets that you can find on the website listed inside are extremely useful in learning as well and best of all, they're free. If you want to learn VBA and dont know where to start, this is the book for you.

John Walkenbach writes in a didactic fashion that allows for good grounding in the basic concepts. For more than beginning VBA dummies, I recommend John's: Excel 2010 Power Programming with VBA. It is the quintessential reference for Excel VBA and with more than three times the material, it is well worth the money.

This book strikes the perfect balance between simplicity and usefulness. Many books aimed at novice programmers simplify the material so much it leaves the reader with a general idea but few practical skills. Mr. Walkenbach did an admirable job in this work providing usable examples and explanations that can be applied in real life situations.

This book is very well explained and perfect for some one who doesn't have a good background in programming. I've been reading it for about 2 months and I can easily perform different tasks using VBA.I also should mention that knowing VBA can really distinguish you from any other person in you career since it makes everything much easier! I strongly recommend start learning VBA using this well structured, easy and inexpensive book.

As usual, Walkenbach hits it out of the park. If you've never used VBA and need to learn the basics, this is a very good place to start. From here you can move on to a bigger and more intimidating book (Walkenbach has one of those too), or just consult Google as needed like everyone else does.Note that this book is explicitly intended as an introduction, and is in no way a complete guide to VBA programming, but it doesn't pretend to be. I mention this only because there's always one guy who gives a book like this a one-star review and complains that it doesn't contain every last detail.