Description
Book SynopsisMaximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, enhanced power, and new capabilities.
Table of ContentsIntroduction 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
