Microsoft Excel 2000 Power Programming with VBA

About the Author John Walkenbach is a principal of JWalk and Associates Inc., a Southern California-based consulting firm specializing in spreadsheet application development. The top-selling author of two dozen spreadsheet books, he is also the "Spreadsheet Tips" columnist for PC World. He developed the Power Utility Pak, an award-winning utility package for Excel, and maintains the Spreadsheet Page, a popular Internet Web site.

Preface. Acknowledgements. PART I: Some Essential Background. Chapter 1: Excel 2000: Where It Came From. Chapter 2: Excel in a Nutshell. Chapter 3: Formula Tricks and Techniques. Chapter 4: Understanding Excel's Files. PART II: Excel Application Development. Chapter 5: What is a Spreadsheet Application? Chapter 6: Essentials of Spreadsheet Application Development. PART III: Understanding Visual Basic for Applications. Chapter 7: Introducing Visual Basic for Applications. Chapter 8: VBA Programming Fundamentals. Chapter 9: Working with VBA Sub Procedures. Chapter 10: Creating Function Procedures. Chapter 11: VBA Programming Examples and Techniques. PART IV: Working with UserForms. Chapter 12: Introducing UserForms. Chapter 13: UserForm Examples. Chapter 14: Advanced UserForm Techniques. PART V: Advanced Programming Techniques. Chapter 15: Developing Excel Utilities with VBA. Chapter 16: Working with Pivot Tables. Chapter 17: Working with Charts. Chapter 18: Understanding Excel's Events. Chapter 19: Interacting with Other Applications. Chapter 20: Creating and Using Add-Ins. PART VI: Developing Applications. Chapter 21: Creating Custom Toolbars. Chapter 22: Creating Custom Menus. Chapter 23: Providing Help for Your Applications. Chapter 24: Developing User-Oriented Applications. PART VII: Other Topics. Chapter 25: Compatibility Issues. Chapter 26: Reading and Writing Text Files. Chapter 27: Manipulating Visual Basic Components. Chapter 28: Understanding Class Modules. Chapter 29: Frequently Asked Questions about Excel Programming. Appendix A: Excel Resources Online. Appendix B: VBA Statements and Functions Reference. Appendix C: VBA Error Codes. Appendix D: ANSI Code Reference. Appendix E: What's on the CD-ROM. Index. End-User License Agreement. CD-ROM Installation Instructions.