Excel Macro Mastery – How You Can Write VBA Like a Professional in 15 Simple Steps

by Paul Kelly

FINALLY! A Way To Create Excel Macros That Won’t Burst Your Brain. Because if you think Excel VBA programmers are smarter or more gifted than you, then you’re mistaken. Truth is, they use dozens of proven programming principles…. little-known techniques that are completely unknown to most Excel users. What are these principles? How can you learn them? And how can you use them to create your own Macros? In 15 Simple Steps, Paul M Kelly teaches you dozens of well-guarded secrets that he learned during his 20+ years as a software developer, including * How to Easily Write to Cells with one line of code – It’s not hard to do once you know the secret * How To Quickly Create Solid Excel Macros - Tons of examples you can “steal” for yourself. * The In Built VBA Tools That Help You Easily Find Bugs – If you think you would make a good detective then you may really enjoy this * How to Solve Any Common Error in Seconds Using the Translator Table – An easy to read error list that should have been written years ago * Why You Only Need ONE Type of Loop in VBA – Learn which of the 7 Loops you will use 99% of the time * Why Using Collections Can Save Hundreds of lines – It’s hard not to do once you know the secret * 3 Key Elements of Excel Macros – The three elements that everyone should know * How to Easily Format any Cell – Changing a cells font, color, format is so simple you could do it now. * How To Easily Open Any Workbook – I provide the code, You can use it everywhere! * This “Evil” Workbook type should never be used – Do You Use It? * What Steps You Should Take To PROTECT Yourself When Building a Real World Macro – Are You Doing Them?

114 pages, Kindle Edition

First published November 25, 2014

Reviews

[Mr Kevin Dooley · Rating 1 out of 5]

Frustrating

This book starts off really well with simple codes you can type yourself and work, the issue is as you get further into the book the codes stop working , this is because they refer to sheets and workbooks that dont exist and at no point in the book are you told to create,name,or download them.

[Vivek Patel · Rating 4 out of 5]

Good For Beginners and for People who don't have programming background

[Waco Glennon · Rating 3 out of 5]

This is a pretty good instructional book. It works on most levels and does do well imparting the idea that macros are not beyond mortals. The language is clear. The examples are appropriate and well done. The author indicates that he is working on a Pareto like principle. Much of what he is trying to teach are the most used and most powerful techniques. He wants to get you programming right away. To me, this is a strong point. Another good point is the book is replete with good tips to make your programming more robust and error proof.

A couple of things to consider about this book

1) The examples are good but there is nothing here that works towards a complete project. i would like to have had something that starts with a basic problem and work through to a solution. There is a chapter the describes an overview, but not a hands on project.

2) You need some experience with programming. Steps are skipped or implied that are known if you have some familiarity with any language (it doesn't have to be VBA). Because of this, the examples may be a little daunting at times because the key words are not well explained in great detail.

3) You will not achieve mastery. I am not sure any book can offer that. This is a second level book. It helps to organize your work after you have started to dabble with VBA for Excel.

[BILL KENNEDY · Rating 3 out of 5]

Macro Primer

Provides an over view of VBA . Mastery may be a goal but is not attained with this book. It is understandably written for the subject matter covered.