3 of 3 people found the following review helpful
Practical and complete, I think it's the best available for now,
Amazon Verified Purchase(What is this?)
This review is from: VBA and Macros: Microsoft Excel 2010 (MrExcel Library) (Kindle Edition)
VBA is no picnic, and I don't think that you will ever find an "easy 10 steps tutorial". If you want to learn VBA, you must be ready to invest much time.
Often many books waste our previous time on explaining everything, 100 pages on the User Interface and all the options, then some silly examples ("Hello World") ad nauseum.
Not this one: it combines some practical examples with simple code, or some very complex code for you to use without trying to understand it. The first 3 chapters are already a gold mine, by explaining how to correct the macro recorder, how to make sure to get the full range of data, and how to select any kind of range. Those are fantastic tips, which you find nowhere else.
After that you dive in the overwhelming range of VBA features, and you can keep this book as wonderful reference.
As always the Kindle version is not the best, especially with the images made of the source code.
This book has a few defects, I have the feeling that it mixes some very complex subjects (f.i. the Events) with more simple ones (R1C1 formulas), and some paragraphs are very obscure. Just pass them and move to the next, there is enough to learn in the easy parts to keep you busy.
I have read 2 more books about VBA: one is a very simple introduction, and the other is also a very big book, which made me sleep. This one is good.