Excel 2010 Power Programming with VBA

All the methods and tools you need to successfully program with Excel John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "e;Mr. Spreadsheet"e; shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel s capabilities with VBA. Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA) Features invaluable advice from "e;Mr. Spreadsheet"e; himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won t find anywhere else This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.

All the methods and tools you need to successfully program withExcelJohn Walkenbach's name is synonymous with excellence in computerbooks that decipher complex technical topics. With thiscomprehensive guide, "Mr. Spreadsheet" shows you how to maximizeyour Excel experience using professional spreadsheet applicationdevelopment tips from his own personal bookshelf.Featuring a complete introduction to Visual Basic forApplications and fully updated for the new features of Excel 2010this essential reference includes an analysis of Excel applicationdevelopment and is packed with procedures, tips, and ideas forexpanding Excel's capabilities with VBA.* Offers an analysis of Excel application development and acomplete introduction to Visual Basic for Applications (VBA)* Features invaluable advice from "Mr. Spreadsheet" himself(bestselling author John Walkenbach), who demonstrates all thetechniques you need to create large and small Excelapplications* Provides tips, tricks, and techniques for expanding Excel'scapabilities with VBA that you won't find anywhere elseThis power-user's guide is packed with procedures, tips, andideas for expanding Excel's capabilities with VBA.

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