Table of Contents
Introduction 1
Part I: Some Essential Background
Chapter 1: Excel 2010: Where It Came From 11
Chapter 2: Excel in a Nutshell 23
Chapter 3: Formula Tricks and Techniques 53
Chapter 4: Understanding Excel Files 77
Part II: Excel Application Development
Chapter 5: What Is a Spreadsheet Application? 101
Chapter 6: Essentials of Spreadsheet Application Development 111
Part III: Understanding Visual Basic for Applications
Chapter 7: Introducing Visual Basic for Applications 135
Chapter 8: VBA Programming Fundamentals 193
Chapter 9: Working with VBA Sub Procedures 241
Chapter 10: Creating Function Procedures 281
Chapter 11: VBA Programming Examples and Techniques 325
Part IV: Working with UserForms
Chapter 12: Custom Dialog Box Alternatives 399
Chapter 13: Introducing UserForms 419
Chapter 14: UserForm Examples 455
Chapter 15: Advanced UserForm Techniques 493
Part V: Advanced Programming Techniques
Chapter 16: Developing Excel Utilities with VBA 543
Chapter 17: Working with Pivot Tables 565
Chapter 18: Working with Charts 583
Chapter 19: Understanding Excel’s Events 639
Chapter 20: Interacting with Other Applications 677
Chapter 21: Creating and Using Add-Ins 703
Part VI: Developing Applications
Chapter 22: Working with the Ribbon 733
Chapter 23: Working with Shortcut Menus 769
Chapter 24: Providing Help for Your Applications 789
Chapter 25: Developing User-Oriented Applications 809
Part VII: Other Topics
Chapter 26: Compatibility Issues 825
Chapter 27: Manipulating Files with VBA 839
Chapter 28: Manipulating Visual Basic Components 871
Chapter 29: Understanding Class Modules 895
Chapter 30: Working with Colors 911
Chapter 31: Frequently Asked Questions about Excel Programming 937
Part VIII: Appendixes
Appendix A: Excel Resources Online 969
Appendix B: VBA Statements and Functions Reference 977
Appendix C: VBA Error Codes 985
Appendix D: What’s on the CD-ROM 989
Index 1007
End-User License Agreement 1053
