If you're already an efficient user of Excel you can now go onto the next stage by making custom Excel solutions that function with VBA. The "For Dummies" guide provides step by step instructions in the familiar "For Dummies" style. This book shows you how to use VBA to make cool Excel programs, write macros, customize your Excel addins and build great dashboards all with VBA.
Some have complained that this book isn't realy for beginners at all. It is well written however and will interest those with some existing VBA knowledge as there is over 300 pages of useful nuggets here. If you love learning by following examples then this book is for you.
An excellent vba book where examples are clear to follow with great illustrations through out. Always heps when a book is visual and demonstrates the topics clearly. Comes with a CD which provides an electronic version of the book so you can read on the iPad on the way to work. I read the 2003 version of this book when I first started with VBA. It taught me how to automate client reports and save hours of time. Some of the more fun aspects are learning how to add splash screens to your report and automate the creation of charts using just VBA.
Those of you who aren't "computer programmers" will be at ease with this book if you've exposed yourself to a recorded macro or two before. The best part of this book is the example short modules you get to test out.
If you're just getting started with Excel VBA and are looking for an introduction to get things started this is the book for you. This book provides you with the skills that you need for practical VBA programming applications. You'll learn how autoamte the creation of pivot tables using just VBA.
Despite the title this is not a basic, intro book. This book as come out of several years of tweaking. This book is good for those still stuck using Excel 2003. Again, this book comes with a CD to aid learning.
There's no better way to learn VBA or macros from a vba book than by examples. This book also does a great job of just showing you what can and can't be done using VBA.