Books

For all its popularity, VBA has a mixed set of documentation especially in book format. The problem is that many Office, VB, and other development books have a chapter or two on VBA. Ditto for some straight VB books. So the attraction oif writing a book devoted to VBA is reduced because there are already covered. Also VBA is such a changing technology the result is the need to change/update the book on a rapid cycle. So the best book, with a 5 star rating from Amazon, is Lewin's VBA for Dummies - one of the first books I used to come up to speed in VBA. Whats nice about this book is its graded exercises in getting developers use to VBA and not just in the Office context.

The second advantage of the book is lots of tables and references to VBA dependent set of utilities and functions. Another advanatge for many will be the broad reach of the book; it does not sit on one Microsoft Office tool and work from their alone. However, having said that - users interested in just Excel VBA or Access VBA will find books devoted to the individual VBA apps - especially if they are popular. Finally, the price is right given the tight market. This is truly a quick reference for the rest of us which makes VBA approachable.