Some Important References for VBA
(Visual Basic for Applications)

Robert de Levie Advanced Excel for scientific data analysis Oxford 2004 (around $60 in paper).

Exellent discussion of VBA and something of its evolution. (Highly recommended)

Tons and tons of good examples and listings of running, debugged routines which can be downloaded (see following)
fourier transforms
error propagation and uncertainties
creating buttons for various tasks

Tons and tons of useful routines already debugged, downloadable from Oxford's site
www.oup-usa.org/advancedexcel

Paul Kenton's VBA site www.vbaphysics.com (Highly recommended.)

Course notes for Computer Applications in physics.

A huge treasure of VBA instruction, mixed with physics problems and examples.

He writes it's fine to use his stuff, but if any financial gain is involved, he should be compensated.

Kimmel, Green, Bullen, Bovey, Rosenberg and Patterson. Excel 2003 VBA Programmer's Reference

Wiley Publishing, 2004

Gets into the guts of VBA. Lots of stuff you won't need and quite a bit that could be useful if you need to do special stuff.

A little bit of stuff on VBA at www.rose-hulman.edu/moloney

VBA Bits and pieces located in the Boise 2002 Workshop