Recommend a Visual Basic for Excel reference book?

[artsandcraftshome]

Can anyone recommend a good reference book for VBA/Excel? I have Reed Jacobsen's Step-by-Step Excel 97 Visual Basic book, which I have found very helpful. However, I am looking for something that is more of a reference for VBA commands and syntax, with examples.

A quick search at Amazon and Half.com gave me the following:
Special Edition Using Excel VB for Apps Jeff Webb
Using Excel VB for Apps Elizabeth Boonin
VB for Apps 5 Bible DF Scott
Excel 2000 VBA programmers Referenc John Green
Microsoft Excel 97 Developer's handbook Eric Wells
Definitive guide to Excel VBA

 

[Tiglet]

On my desk as we speak is Excel 2000 VBA Programmer's Reference and Step by Step MS Excel 97 VB by Reed Jacobson (had this one longer!!).

I would say they complement each other fairly well.

The Big Red Bible (Excel 2000 VBA) has long lists and tables giving details of Range Properties etc so is quite useful but it is all to do with personal preference at the end of the day. A really good couple of books I also use are:

Using Excel VBA for Applications by Elisabeth Boonin (Simple yet so clear)
Writing Excel Macros by Steven Roman is a great reference book with lists of objects etc too.

I have discovered that no single book seems to give all the answers you want so pick one you like the colour of, you are bound to buy another one sooner or later!!!!

 

[bryanbayfield]

I bought the Steve Roman one first - that was a very good one to start with.

There's also a Wrox one that I've bought that really has more info in it than I need - eg stuff like how you can change your screen resolution from Excel using the Windows API, can't imagine any one having a dying need for that info. However, it's got some good stuff in it that wasn't in Steve Roman's book.

The Wrox book also has a very large appendix detailing all of the properties/ method's etc of all the objects. To be honest I don't think you need a massive reference for VBA's commands, it's more the objects that you need to know. But then the programming environment has an object browser anyway, so you shouldn't buy a book just for that.

Hope this is of some use. Amazon does have a space for customer reviews - having bought some books because of the positive reviews, I've found them to be quite accurate.