I bought John Walkenbach's book, Microsoft Excel 2010 Power Programming with VBA. It is very thick, almost 2.5", and 1051 pages. It comes with a CD with sample Excel files and a copy of the book. Plenty of pictures and sample code.
Part I: Some Essential Background
Chapter 1: Excel 2010: Where it came from
Chapter 2: Excel in a Nutshell
Chapter 3: Formula Tricks and Techniques
Chapter 4: Understanding Excel Files
Part II: Excel Application Development
Chapter 5: What is a Spreadsheet Application
Chapter 6: Essentials of Spreadsheet Application Development
Part III: Understanding Visual Basic for Applications
Chapter 7: Introducing Visual Basic for Applications
Chapter 8: VBA Programming Fundamentals
Chapter 9: Working wiht VBA Sub Procedures
Chapter 10: Creating Function Procedures
Chapter 11: VBA Programming Examples and Techniques
Part IV: Working with UserForms
Chapter 12: Custom Dialog Box Alternatives
Chapter 13: Introducing UserForms
Chapter 14: UserForm Examples
Chapter 15: Advanced UserForm Techniques
Part V: Advanced Programming Techniques
Chapter 16: Developing Excel Utilities with VBA
Chapter 17: Working with Pivot Tables
Chapter 18: Working with Charts
Chapter 19: Understanding Excel's Events
Chapter 20: Interacting with Other Applications
Chapter 21: Creating and Using Add-Ins
Part VI: Developing Applications
Chapter 22: Working with the Ribbon
Chapter 23: Working with Shortcut Menus
Chapter 24: Providing Help for Your Applications
Chapter 25: Developing User-Oriented Applications
Part VII: Other Topics
Chapter 26: Compatibility Issues
Chapter 27: Manipulating Files with VBA
Chapter 28: Manipulating Visual Basic Components
Chapter 29: Understanding Class Modules
Chapter 30: Working with Colors
Chapter 31: Frequently Asked Questions about Excel Programming
Part VIII: Appendixes
Appendix A: Excel Resources Online
Appendix B: VBA Statements and Functions Reference
Appendix C: VBA Error Codes
Appendix D: What's on the CD-ROM
Index
End User License Agreement
Part I: Some Essential Background
Chapter 1: Excel 2010: Where it came from
Chapter 2: Excel in a Nutshell
Chapter 3: Formula Tricks and Techniques
Chapter 4: Understanding Excel Files
Part II: Excel Application Development
Chapter 5: What is a Spreadsheet Application
Chapter 6: Essentials of Spreadsheet Application Development
Part III: Understanding Visual Basic for Applications
Chapter 7: Introducing Visual Basic for Applications
Chapter 8: VBA Programming Fundamentals
Chapter 9: Working wiht VBA Sub Procedures
Chapter 10: Creating Function Procedures
Chapter 11: VBA Programming Examples and Techniques
Part IV: Working with UserForms
Chapter 12: Custom Dialog Box Alternatives
Chapter 13: Introducing UserForms
Chapter 14: UserForm Examples
Chapter 15: Advanced UserForm Techniques
Part V: Advanced Programming Techniques
Chapter 16: Developing Excel Utilities with VBA
Chapter 17: Working with Pivot Tables
Chapter 18: Working with Charts
Chapter 19: Understanding Excel's Events
Chapter 20: Interacting with Other Applications
Chapter 21: Creating and Using Add-Ins
Part VI: Developing Applications
Chapter 22: Working with the Ribbon
Chapter 23: Working with Shortcut Menus
Chapter 24: Providing Help for Your Applications
Chapter 25: Developing User-Oriented Applications
Part VII: Other Topics
Chapter 26: Compatibility Issues
Chapter 27: Manipulating Files with VBA
Chapter 28: Manipulating Visual Basic Components
Chapter 29: Understanding Class Modules
Chapter 30: Working with Colors
Chapter 31: Frequently Asked Questions about Excel Programming
Part VIII: Appendixes
Appendix A: Excel Resources Online
Appendix B: VBA Statements and Functions Reference
Appendix C: VBA Error Codes
Appendix D: What's on the CD-ROM
Index
End User License Agreement
Here's the table of contents to Power Programming with VBA.
