Learn more Download now Shop now Shop now Shop now Shop now Shop now Shop now Shop now Shop now Learn More Shop now Learn more Shop Fire Shop Kindle Amazon Music Unlimited for Family Learn more Shop now Learn more

on 6 October 2013
NOTE - Added 03.01.2017 - I wrote this review for the 3rd edition of this book, but have since noticed that Amazon also lists it when you view reviews for the 4th edition, I cannot comment on the 4th edition as I have not read it!

To put my review into a meaningful context, I will say now that I have been programming for 2-3 years. The thing with this book though, is that almost nowhere within it did I encounter any terminology I would have found intimidating as a beginner. I had wanted to program VBA as it is enormously useful and this book was exactly what I was after.

The author begins by stating the strengths of Excel VBA and also it's history which is interesting enough. He then goes on to talk about the way that VBA programs are structured (if, for, while statements etc.) and how to write handy subroutines and functions. All the while the code is kept to small examples between 5-20 lines and I found that I learnt quickly from copying and tweaking them. These succinct code snippets definitely made progress quick and I found myself using what I had learnt practically straight away in my job.

The books aim is this: To get you to a good enough level of VBA that you can structure your programs nicely and create nice looking forms but giving you the knowledge you need to delve fearlessly into the standard help documentation. Once I had understood how to initialize my variables and write loops and conditional statements, browsing the help led to me finding all sorts of fantastic functions and methods that I had been previously ignorant of. As a result I would say my productivity increased considerably.

The author also provides, early on, a very important chapter on the Excel Object Model(which tells you how the Excel objects are linked to one another) and once you have an understanding of this, the rest will come much more easily. Later on, Chart Objects and User Forms are covered and I think this is the level to which most people would be happy to get to. The examples are well explained and there are no unpleasant large chunks of code left without explanation.

This intro assumes no prior knowledge of anything computer related (provided you can turn your PC on and know how to open Excel of course!) and is ideal for the beginner. Furthermore, Excel (indeed MS Office) is ubiquitous and learning a bit of VBA can be rewarding and eventually save you a lot of time. One of the aspects I did like was the author's tendency to clearly explain using examples and not some silly analogy (which I have experienced in Dummies guides before). Additionally, key points are made and then re-iterated throughout the text.

Mr Spreadsheet, as the author is also known also has a great web page with many VBA programs and ideas on it, that I found myself making large use of. He also has what I guess is a follow-up book to this, which may be my next port of call.

All in all, if you want to learn VBA this is a very good place to start for the experienced programmer and the beginner alike. Although I would have liked to have seen a bit more on Chart Objects. I would also like to apologise for the poor and rather dull structure of this review, I am no Shakespeare!
0Comment| 45 people found this helpful. Was this review helpful to you? Report abuse
on 18 July 2016
"Dummies" at it's best - loads of examples, clearly explains the "object model" I'm a fairly experienced programmer, so was easy to understand, but beginners may struggle to follow the fairly steep "learning curve", unfortunately there's no easy way make the jump between casual Excel user to codemaster
0Comment| 2 people found this helpful. Was this review helpful to you? Report abuse
on 26 September 2017
I've been going through this book each week for the past few months. It is easily understandable, and the author has done a great job of making the technical normal. However I just don't feel like I'm learning much, every time I am starting to get to grips with something the book tells me that the rest of it will be told in Chapter X, when I get to these chapters I don't really find the necessary information that links them together but instead am referenced to yet another chapter. I mean no disrespect but It seems like there is too much unnecessary waffle for my liking.
0Comment|Was this review helpful to you? Report abuse
on 12 January 2013
From knowing nothing about VBA, using this book I wrote quite an extensive set of macros for a significant Excel workbook used in our laboratory. The only real downside is that although it covers most of what the beginner needs and in fair depth, looking things up is difficult, because although a topic is almost always covered somewhere in the book, finding the relevant page is hard as the index is so incomplete. With a more comprehensive index, with lots more references to where VBA words and functions can be found in the book, this would definitely be five stars, not four. Perhaps the later edition written around Excel 2010 is better in this respect - but I was using Excel 2003.
0Comment|Was this review helpful to you? Report abuse
VINE VOICEon 26 December 2016
Clear writing, covers most of the ground needed. Personally I could use a tad more depth but the online help is better as a reference anyway. Usual Dummies style, you either love it or loathe it...
0Comment|Was this review helpful to you? Report abuse
on 19 November 2017
This is a good book but I found it took such a long time to get to the juicy bits of programming. Well written and amusing though
0Comment|Was this review helpful to you? Report abuse
on 20 October 2015
Great Ebook brought me back to speed very quickly.
I would have liked a better way to surf the pages for example
"I would like to know how to do this" then fly to the page I need, but over all a good book full of info and easy to understand
0Comment|Was this review helpful to you? Report abuse
on 28 May 2014
This book is a smaller version of Excel 2013 Power Programming with VBA also written by the same author. It is a handy book to carry in a laptop case to have as a reference wherever you may be. Naturally does not contain as much in his Power Programming book but you could not carry it about.
Well worth buying.
0Comment| 5 people found this helpful. Was this review helpful to you? Report abuse
on 29 October 2017
All dummies books are slow, but difficult to find specific bits
0Comment|Was this review helpful to you? Report abuse
on 18 June 2017
Great book. I know a fair amount already and learned a lot more
0Comment|Was this review helpful to you? Report abuse

Sponsored Links

  (What is this?)