"Excel 2007 Macro Programming With VBA" by John Walkenbach

Anything by this author is a good place to start. Note, though, that you will
still be using VBA6 while MS Office moved on to VBA7 in v2010. As before, I
encourage you to go with at least v2010 moving forward because it is the base
for all recent versions. (just saying v2007 is no place for a serious developer
to be *spending* time/energy to learn! Hang onto your v2003 and pick up v2010
at the 1st opportunity!)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion