Dummies.com
  • Print
  • Share
Excel 2003 Power Programming with VBA (1118043979) cover image

Excel 2003 Power Programming with VBA

ISBN: 978-1-118-04397-4
E-book
1056 pages
June 2011
How to read this e-book on:
Adobe e-books are read using Adobe Digital Editions. Install Adobe Digital Editions on your PC in order to read or transfer your 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