Excel VBA: for Non-Programmers (Programming in Everyday Language)

I wish I had found this book when I was first getting started with VBA. It tackles all of the stuff that you need in the beginning, for example selecting cells and ranges. I especially like the sections on sorting and filtering. You would think that every book on VBA would cover these topics in detail, but I have found that to not be true. After learning VBA using online sources, I know most of the material in this book. However, I am keeping it because it is a great resource for the basics. I am still learning about arrays, and this book has a great section on that. I hope that the author, Mayaan Poleg, will continue writing books about Excel VBA. She really understands the needs of beginners. Also, do not confuse Poleg’s book with others with a similar cover. I did not like the intro books by David Williams. Poleg’s is much better. For a more advanced book, I also like Microsoft Excel 2019 by Bill Jelen and Tracy Syrstad. Good luck to everyone learning VBA. It took me a couple of months, but now I love it. One suggestion: create a document in MS Word where you can save pieces of code, e.g., offset, re-size, re-ordering columns, etc. You are basically creating your own user guide. I have a Word doc that I call Core Pieces of Code that I refer back to almost daily. I keep all my code in my personal workbook. You can also print all the modules in your personal workbook to a pdf (right-mouse click on any module, click print). I hope that all the newbies stick with it. It is well worth the effort and training, and can be a lot of fun! Just be prepared to do a lot of debugging and trial and error. That is one of the best ways to learn.

Good entry level introduction. Quickly outgrown for those who pursue VBA expertise but definitely worth the price as an introduction and handy reference.

Great book! I have been looking for a long time for a good simple guide that will explain me complicated things. I just found it. I found everything I need in this book. It is clear, it is fluid, it has no complicated terms. Thanks to this book I was able to overcome my fear of programming. Thank you!

While the book seems well written for the likes of me, the link provided to download the example workbooks does not work, nor does there seem to be a viable solution. Lame. I had high hopes for this book.

The book takes you one step at a time, each step very clear and following to the next one. Just like the title of the book – you don't need to have any knowledge in code writing when starting this book – but you can certainly write codes when you're done with the book. The screen shots are very helpful and clear. Recommended for anyone who knows excel and wants to take it to the next level.

I would not recommend this book to non-programmers. There is not enough instructions for non-programmers to become productive using VBA. There are plenty of other books that are more informative. To me, the author appeared to begin writing a book and shortly there after abandon her project. You will not get anything out of this. Spend your money elsewhere.

The website in the book doesn't have the Excel table to download. General overview no real information or exercises if your not a programmer already. I understood the concepts but came away with nothing.

I consider myself as a fairly experienced weekend programmer (python,c++, javascript etc.,) However, I have never touched VBA before. Time over time I thought about learning VBA but never had a chance. I finally looked up Amazon when I was given a task list in Excel form which needed a serious reworking. the list item count was about 400. Some of the item need to be duplicated multiple times par the information on one column value. I could do this manually but I figured it will take a half day and it will be boring. so I downloaded the book and start reading. I went through the whole material in one sitting. I started to experiment with the test file when I was at 50% of the book, at 80% of the book, I had a working VBA code that solved my problem. and now I have a cleaned up list with 600+ item count. Since I already knew about decision tree and looping, What I needed to start learning was how the program will interact with Excel cells and its contents. The book gave me these learning points very quickly. Also the author introduce "record macro" as the way to read and learn the VBA code and debugging technique early in the book. this turned out to be very helpful. Money and time worth spent. It was an exciting three hours.

Good help.

a useful book.

keep it simple and goes into more complex argument step by step

Very good guide to layman also No program knowledge people also can write program. Good good good good good good

It seems to be an older type of book, very simplistic without exercises for users to practise on. I was disappointed