Reference books for VBA

Can anyone recommend some good reference-type books for VBA?

I already have a few general books (e.g. "Excel 2002 Power Programming with VBA" by John Walkenbach) which are good for an overview, but I want something that explains more about the specific VBA objects e.g. what they can do, programming syntax, object properties and so on.

I could probably Google for some books but I'd rather have someone recommend something so I know it will actually be useful.

Thanks
-Rob

I have gotten a lot of mileage out of "Definitive Guide to Excel VBA" by Michael Kofler (a! Apress). At the end of each section it has a nice (though very brief) "Syntax Summary" with a listing of the relevant Objects, Methods, Properties, etc. This has proven to be very helpful to me.

Check out this thread:

http://www.vbforums.com/showthread.php?t=341155

VBAhack