VBA Book

[Ed]

Can anyone recommend the most comprehensive book to reference for
VBA?

Thanks


Ed

 

[Tim Zych]

VB and VBA In A Nutshell by Paul Lomax. IMO best "reference" book out there.

 

[Bob Phillips]

I prefer Excel VBA Programmers Reference, Bullen, Bovey & Green. I have the
2000 version, avoid the 2003 version like the plague. There is a 2007
version which I have not seen.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Tim Zych]

Interesting. This is where our individual needs drive our usage. When I
think of a reference book, I think of very quickly being able to find a
place in the book that explains something. VB/VBA Nutshell, being organized
in alphabetical order kind of like a dictionary, enables that. It also has
"perfect binding" (at least my old copy does), where it lays flat on my desk
and *stays put* when I am reading and typing. The Wrox books don't. They
require 2 hands to hold, look for a page, hold it open with elbows and
hopefully not crack the spine. Actually I ended up cracking the spines of
both of them through normal usage. My estimation of what makes a good book
includes construction, indexing, page notations, font, paper quality, etc.
As well as writing.

Guess the OP's going to have to see what works for him!

 

[Bob Phillips]

I think it is more to how we interpreted the question. If you want pure VBA
reference (but why, VB/VBA is so simple, and there is help), the Lomax's
book is better. But as the guy is posting in an Excel group, I figured he is
interested more in Excel VB add-ons, hence the Programmers Reference wins
hands down (in fact there is no contest, Lomax doesn't even touch Excel).

As for buying a book because it lays better on the desk, well ...

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)