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

About the Author

John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 50-plus books include John Walkenbach's Favorite Excel 2010 Tips & Tricks, Excel 2010 Formulas, and the bestselling Excel Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com.