http://www.amazon.com/Excel-2007-VBA-Macro-Programming/dp/0071627006/ref=sr_1_1?s=books&ie=UTF8&qid=1321997451&sr=1-1

Book Description
By Richard Shepherd
ISBN-10: 0071627006 | ISBN-13: 978-0071627009 | Publication Date: September 3, 2009 | Edition: 2

Develop custom Excel VBA macros

Perfect for power users, this practical resource reveals how to maximize the features and functionality of Excel 2007. You'll get in-depth details on Excel VBA programming and application development followed by 21 real-world projects--complete with source code--that show you how to set up specific subroutines and functions. The book then explains how to include the subroutines in the Excel menu system and transform a set of interrelated VBA macros into an Excel add-in package. Create your own Excel 2007 VBA macros right away with help from this hands-on guide.

Excel 2007 VBA Macro Programming shows you how to:

    *
      Write and debug VBA code
    * Create custom dialog boxes and buttons
    * Maximize the Excel object model
    * Write code to interact with a database
    * Add functionality to your programs with API calls
    * Insert class modules
    * Develop custom menus for the Ribbon
    * Animate objects in Excel
    * Create and manipulate Pivot Tables in VBA
    * Expand calculation and search functions
    * Create full-fledged Excel add-ins