Learning to use VBA

April 6, 2013 9:31 PM

I have read that John Walkenbach's books are the de-facto standard for learning to use VBA in Microsoft Excel. I'd like to know what books are recommended to learn to use vba in other Office products - primarily Access, but also Word and Powerpoint. I'm more interested in books than in websites.
posted by Proginoskes to Computers & Internet (3 answers total)

I've found this book useful for learning vba for Access.
posted by jasper411 at 6:51 AM on April 7, 2013

They say that if you understand vba in one office application that this easily translates to other office applications, but I have only worked with vba in access. I learned most from this and this. The first is very pragmatic and taught me im a quick way how to get things done, but the second is much more detailed and contains more information than I've been able to process so far.

This assumes that you know how access works. Otherwise I really recommend starting with this awesome book to get started with queries, tables and forms (although it is very light on vba).
posted by IAr at 10:28 AM on April 7, 2013

You can download some free sample chapters of Learn Access 2003 VBA with The Smart Method to see if you like its approach. As a non-programmer I've found it easy to follow, as an intro to VBA.
posted by hsieu at 9:37 PM on April 7, 2013