Dear customers, please be informed that our shopping cart will be unavailable between August 21 and September 1, 2014, as we will be making some changes to serve you better. To minimise any possible delivery disruption, we encourage you to make your purchases before August 21. We appreciate your understanding and apologise for any inconvenience.

Dummies.com
  • Print
  • Share
  • Get technical support for this product
Excel 2003 Power Programming with VBA (0764540726) cover image

Excel 2003 Power Programming with VBA

ISBN: 978-0-7645-4072-1
Paperback
1056 pages
January 2004
US $49.99 Add to Cart

This price is valid for United States. Change location to view local pricing and availability.

Other Available Formats: E-book
Preface.

Acknowledgments.

Part I: Some Essential Background.

Chapter 1: Excel 2003: 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: Custom Dialog Box Alternatives.

Chapter 13: Introducing UserForms.

Chapter 14: UserForm Examples.

Chapter 15: Advanced UserForm Techniques.

Part V: Advanced Programming Techniques.

Chapter 16: Developing Excel Utilities with VBA.

Chapter 17: Working with Pivot Tables.

Chapter 18: Working with Charts.

Chapter 19: Understanding Excel’s Events.

Chapter 20: Interacting with Other Applications.

Chapter 21: Creating and Using Add-Ins.

Part VI: Developing Applications.

Chapter 22: Creating Custom Toolbars.

Chapter 23: Creating Custom Menus.

Chapter 24: Providing Help for Your Applications.

Chapter 25: Developing User-Oriented Applications.

Part VII: Other Topics.

Chapter 26: Compatibility Issues.

Chapter 27: Manipulating Files with VBA.

Chapter 28: Manipulating Visual Basic Components.

Chapter 29: Understanding Class Modules.

Chapter 30: Frequently Asked Questions about Excel Programming.

Part VIII: Appendixes.

Appendix A: Excel Resources Online.

Appendix B: VBA Statements and Functions Reference.

Appendix C: VBA Error Codes.

Appendix D: What’s on the CD-ROM.

Index.

End-User License Agreement.

  • Print
  • Share
  • Get technical support for this product