Excel Vba Programming For Dummies, 4e

If you don't know where to start with Excel VBA, this book is very helpful.Don't mistake the beginning for the end: this book points you in the right direction, but it can't help you MASTER VBA. If you follow the directions, you will learn how to start exploring the world of VBA and how to teach yourself--this book is only meant to give you the framework to hang later learnings upon.Overall, very clear, a well-thought-out sequence, and I LOVED the intro to "object oriented programming."Ignore reviews complaining that the book didn't tell them how to do this or that particular thing. The purpose is to get you oriented, and to empower you to start looking for other resources to solve this or that particular problem. The book does a marvelous job in outlining the main points of what Excel VBA is all aobut.

I recently was offered training in VBA by a mentor and he pointed me to this book. I think it's a great start for all levels of programmers.Like many programming languages, there are similar nuances but the key words differ. This book does a great job of slowly diving in and easing you into VBA.The examples and exercises that come with the book also help tremendously. Reading and learning the language can only go so far, case study and practical examples is what really gets you acclimated to creating macros.

As a total rookie when it comes to programming, this book was easy to follow. My only complaint is the Author seems to put forth less effort as the material gets harder to grasp. In the beginning he really breaks it down to a science and walks you through every step of the process and explaining what is happening along the way. The first time that you are required to participate and create something on your own spreadsheet, he even asks you how how you'd go about making the font italic so you could actually start doing and learning. I don't think that happens again during the rest of the book. The beginning was very well written and I feel that if he would have taken as much time explaining how an array works as he did for a macro, I would have enjoyed it and learned so much more.

Never one to avoid a challenge, I decided to learn VBA for some of my more advanced spreadsheets. I was an IT professional in my pre-retirement life so programming was something I truly enjoyed. This book, or rather what I've learned from it, has been a source of enjoyment for me and will continue to be for some time. John Walkenbach's writing style is new to me. Having teethed on IBM's "Principles of Operation" to learn BAL (Basic Assembler Language) the use of humor in the text was genuinely appreciated. I've learned a lot from this book that has helped with some real-life problems I've encountered with Excel.

VBA programming for MAC is different from the Windows version. I have been told by Excel "experts' not to even bother with the Mac version. Still the book is somewhat helpful because the syntax for both versions is the same. The VBA editor and program management tools for Excel for MAC are pathetic and the book cannot help.

This book is an easy read. The language is simple and human. This is a programming book written for the novice who wants to get a grasp on Excel VBA programming. I've read the first two chapters at this point and I feel like I've learned a good bit and it has stuck. I don't feel like I have to go back and study a lot since I apply it as I read it.I really enjoy the practices that goes along with what you're learning. There's no better way to learn that actually doing it!

Thank you John Walkenbach. I bought this book intending to cherry pick some ideas and ended up reading it cover to cover (Can you do that with a Kindle?). I loaded 95% of the examples into workbooks and tinkered with them for hours. If you are using Excel VBA do yourself a favor and buy this book and you too will be thanking John.

If this book is for dummies I must need the book for the extremely dumb. Could not even get the 1st sample macro to work properly and I have wrote a few of my own prior to buying this book. I have Excel 2010 and 2016 and neither one worked. Thank you Amazon for taking returns.