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!

This is a good guide for starting out with Excel VBA if you don't have much programming experience and you're competent in Excel (this book is aimed toward versions 2010 and 2013). I work with Excel very regularly and have to crunch data that's thousands of lines long at times, and this book has improved automating tasks I need to perform.

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.

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.

It does not cover the mac version of Excel which is a limitation to its overall utility for me. I found that it did not emphasize user forms enough and did not cover examples of how to display the output data from analytical Excel tools. As such, it was not a great reference to many problems I found in developing analytical models in Excel.

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.

Wow, I wanted to get started with VBA, and I bought this book along with reading everything I can on the web. This is very well written, not only informative, but Mr. Walkenbach makes it fun. I HIGHLY recommend to any one who wants to learn VBA coding correctly. Learning VBA will be a process for me, and I'm very happy I chose to use this book as a starting point.

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.