An excellent resource for getting up to speed on developing spreadsheet applications using VBA Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Introduction   1 Part I: Some Essential Background Chapter 1: Excel in a Nutshell   11 Chapter 2: Formula Tricks and Techniques     39 Chapter 3: Understanding Excel Files      75 Chapter 4: Essentials of Spreadsheet Application Development    97 Part II: Understanding Visual Basic for Applications Chapter 5: Introducing Visual Basic for Applications   119 Chapter 6: VBA Programming Fundamentals    177 Chapter 7: Working with VBA Sub Procedures     227 Chapter 8: Creating Function Procedures     269 Chapter 9: VBA Programming Examples and Techniques       317 Part III: Working with UserForms Chapter 10: Custom Dialog Box Alternatives    395 Chapter 11: Introducing UserForms  417 Chapter 12: UserForm Examples   453 Chapter 13: Advanced UserForm Techniques     491 Part IV: Advanced Programming Techniques Chapter 14: Developing Excel Utilities with VBA     543 Chapter 15: Working with Pivot Tables      565 Chapter 16: Working with Charts    583 Chapter 17: Understanding Excel’s Events      645 Chapter 18: Interacting with Other Applications     685 Chapter 19: Creating and Using Add-Ins      711 Part V: Developing Applications Chapter 20: Working with the Ribbon     743 Chapter 21: Working with Shortcut Menus      779 Chapter 22: Providing Help for Your Applications     801 Chapter 23: Developing User-Oriented Applications  821 Part VI: Other Topics Chapter 24: Compatibility Issues   837 Chapter 25: Manipulating Files with VBA      851 Chapter 26: Manipulating Visual Basic Components   885 Chapter 27: Understanding Class Modules      911 Chapter 28: Working with Colors    927 Chapter 29: Frequently Asked Questions about Excel Programming    953 Part VII: Appendixes Appendix A: VBA Statements and Functions Reference     989 Appendix B: VBA Error Codes    999 Appendix C: This Book’s Website  1003 Index    1019