Microsoft Excel 2013 Power Programming with VBA (Paperback)

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