A place to start is http://spreadsheetpage.com/Originally Posted by PSL
Check out John WAlkenbach's book, listed at that web site.
Start with the Power Programming and Formulas books.
Also, http://www.bmsltd.co.uk/ProExcelDev/Default.htm
A quick start, if still published, would be the MSFT Press' Excel VBA Step by Step.