Shop now Shop now Shop now  Up to 50% Off Fashion  Shop all Amazon Fashion Cloud Drive Photos Shop now Learn More Shop now Shop now Shop Fire Shop Kindle Listen with Prime Shop now Shop now

Customer Reviews

4.4 out of 5 stars36
4.4 out of 5 stars
Your rating(Clear)Rate this item

There was a problem filtering reviews right now. Please try again later.

on 6 October 2013
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|29 people found this helpful. Was this review helpful to you?YesNoReport abuse
on 8 May 2014
I find this book of little use but as I say, it is probably my own fault. If you've not really used spreadsheets before and find the thought of programming in any language baffling, then the book is for you. I'm already an engineering professional and thought it'd be helpful to know a bit more VB, specifically when i'm writing macros for sorting data etc.. Not a particularly good reference book but would be great if you're a complete beginner.
11 comment|4 people found this helpful. Was this review helpful to you?YesNoReport 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|3 people found this helpful. Was this review helpful to you?YesNoReport abuse
on 8 October 2014
This book offers a good overview of VBA and having worked through it I can say that it is very useful. However, I found that some of the exercises simply do not work when attempted and have found other online forums where people are complaining about basic mistakes and problems in the code the book gives for the user to work with. Also, the jovial, attempts at funniness in the book are nice but when we are trying to learn a complex and vital part of the language I would prefer it is the author were to the point. I don't care about mind reading in Excel 2016. I want to know about how VBA works! Please cut down the jokes for the future and concentrate on more explanation- I don't want to have to read double the amount for half the knowledge- I want a joke book I'll buy one.
0Comment|Was this review helpful to you?YesNoReport abuse
on 7 May 2014
OK if you are a bit of a Techi with some programming experience in other languages, but needs reading a few times to understand the concepts. Need a good grounding in Excel first and have some reson in mind wanting to learn VBA in the first place.
0Comment|One person found this helpful. Was this review helpful to you?YesNoReport abuse
on 21 February 2015
Very informative book, is great for helping you to improve the way you create VBA code.

I was a complete novice but this has helped me to improve how I perform my tasks at work creating simple and complex macros to speed up working.
0Comment|One person found this helpful. Was this review helpful to you?YesNoReport abuse
on 18 November 2014
This is an excellent introductory book on VBA and gave me a solid grounding in VBA in only a couple of weeks. The author writes in a generally entertaining way and his enthusiasm about VBA makes the book less dry to read than some titles.

The author is also honest about the pros and cons of VBA, and gives some context about when it is useful or when general purpose programming languages would be more appropriate.

Overall this book gives the reader a solid grounding in programming VBA macros on Excel and I'd strongly recommend it.
0Comment|Was this review helpful to you?YesNoReport abuse
on 3 January 2014
I have been using VBA for years. I like the author's style and often borrow this book from others. Just thought it was time I got my own copy.
0Comment|One person found this helpful. Was this review helpful to you?YesNoReport abuse
on 25 April 2014
Excel VBA Programming For Dummies -An excellent book especially for an introductory into VBA programming within Excel. Well worth the read.
0Comment|One person found this helpful. Was this review helpful to you?YesNoReport abuse
on 29 May 2014
This book quickly took me from complete beginner to a reasonably high level of confidence. Well written with a good balance between examples and theory. All the examples given are explained in appropriate detail, it covers the main topics, and explains how to write clear, organised and understandable code.
0Comment|Was this review helpful to you?YesNoReport abuse

Send us feedback

How can we make Amazon Customer Reviews better for you?
Let us know here.

Sponsored Links

  (What is this?)