Listmania!
Excel VBA and related
By an Amazon.com customer
Practical Management Science (with CD-ROM Update): Spreadsheet Modeling and ApplicationsPractical Management Science (with CD-ROM Update): Spreadsheet Modeling and Applications by Wayne L. Winston
Buy used from: $0.68
Excel applied to Management Science. Nice excel examples, learn Linear programming, solver, naming ranges, see various excel function examples in context, etc here.
Excel 2000 FormulasExcel 2000 Formulas by John Walkenbach
Buy new: $29.88 / Used from: $2.40
Array functions, string manipulation, lookups. Also contains some VBA function sections but redundant with the companion below. Check the latest edition.
Microsoft® Excel 2000 Power Programming with VBAMicrosoft® Excel 2000 Power Programming with VBA by John Walkenbach
Buy new: $31.49 / Used from: $0.93
This book lacks in coverage of API, class module, but good intro and good coverage. Check the latest edition.
VBA Developer's Handbook, 2nd EditionVBA Developer's Handbook, 2nd Edition by Ken Getz
Buy new: $31.49 / Used from: $10.00
Fill in the part of API, class module, error handling techniques and much more.
VBA for Modelers: Developing Decision Support Systems Using Microsoft® ExcelVBA for Modelers: Developing Decision Support Systems Using Microsoft® Excel by S. Christian Albright
Buy used from: $19.48
This book accompamies Practical Management Science book above. The part II is nice application based examples.