Jim DeMarco's new book on Excel VBA is a great choice for users who have a good general knowledge of Excel and want to learn how to write code using class modules.
This is a very good introduction to OOP in VBA. The book covers data import, XML, buiding user forms, charting, pivot tables, and Office integration.
Worth getting.