VBA Book
 

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

Thanks


Ed

VBA Book
 

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

--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility



"Ed" wrote in message
...
Can anyone recommend the most comprehensive book to reference for
VBA?

Thanks


Ed

VBA Book
 

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" <tzych@NOSp@mE@RTHLINKDOTNET wrote in message
...
VB and VBA In A Nutshell by Paul Lomax. IMO best "reference" book out
there.

--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility



"Ed" wrote in message
...
Can anyone recommend the most comprehensive book to reference for
VBA?

Thanks


Ed

VBA Book
 

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!


--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"Bob Phillips" wrote in message
...
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" <tzych@NOSp@mE@RTHLINKDOTNET wrote in message
...
VB and VBA In A Nutshell by Paul Lomax. IMO best "reference" book out
there.

--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility



"Ed" wrote in message
...
Can anyone recommend the most comprehensive book to reference for
VBA?

Thanks


Ed

VBA Book
 

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)

"Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNET wrote in message
...
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!


--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"Bob Phillips" wrote in message
...
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" <tzych@NOSp@mE@RTHLINKDOTNET wrote in message
...
VB and VBA In A Nutshell by Paul Lomax. IMO best "reference" book out
there.

--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility



"Ed" wrote in message
...
Can anyone recommend the most comprehensive book to reference for
VBA?

Thanks


Ed