John Walkenbach's Power Programming with VBA is an excellent starting point, as well as good reference material as you go.