Request for book suggestions

[Patricia Shanahan]

I am a very experienced programmer, but new to VBA. I am using it in MS
Office 2007 Excel. I have read a couple of basic books, and can make VBA
do what I want, but I need at least one book with good coverage of the
following topics:

1. User defined classes and interfaces.

2. Style. What does good, maintainable VBA look like?

3. VBA design patterns.

Thanks for any suggestions,

Patricia

 

[Steve Rindsberg]

I am a very experienced programmer, but new to VBA. I am using it in MS
Office 2007 Excel. I have read a couple of basic books, and can make VBA
do what I want, but I need at least one book with good coverage of the
following topics:

1. User defined classes and interfaces.

2. Style. What does good, maintainable VBA look like?

3. VBA design patterns.

For your purposes, VBA is pretty much the same as VB5/6 (though not
VB.net)

While there aren't many books that cover VBA thoroughly, there are a LOT
of them that tackle VB5/VB6. Nearly everything you learn about VB5/6 will
be directly applicable to VBA and in fact most VB code, other than forms
and a few other odds and ends, can be copy/pasted into VBA modules and
used w/o modification.