| Table of Contents |
| | Excel 2007 Power Programming with VBA |
| | Preface |
| Part I - Some Essential Background |
| | Chapter 1 | - | Excel 2007-Where It Came From |
| | Chapter 2 | - | Excel in a Nutshell |
| | Chapter 3 | - | Formula Tricks and Techniques |
| | Chapter 4 | - | Understanding Excel's 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 with 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 |
| | List of Figures |
| | List of Tables |
| | List of Listings |
| | List of Sidebars |
| | CD Content |