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

About the Author

John Walkenbach, arguably the foremost authority on Excel, has written 50+ books, including multiple editions of the bestselling Excel Bible and Excel Formulas, as well as more than 300 articles for publications such as PC World, InfoWorld, and Windows. He created the award-winning Power Utility Pak and provides Excel information and insight at www.spreadsheetpage.com.

Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.

About Fishpond

You can earn a 8% commission by selling Excel 2013 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!

Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!

Submit Information

Table of Contents

About the Author