I read through at least 4-5 books on VBA... Mr Excel, Mr Spreadsheet and a few others... another that helped was Master Visually excel 2003 vba programming...
If you live near akron, oh. Bill Jelen (mr excel) has a one day workshop that is outstanding... the class made a word of difference for me getting me started in the "right" direction.