Link to the ebook : https://login.ezproxy.univ-catholille.fr/login?url=https://s...

eISBN : 9781118491805

Contents : Introduction
Part I: Some Essential Background
Chapter 1: Excel in a Nutshell
Chapter 2: Formula Tricks and Techniques
Chapter 3: Understanding Excel Files
Chapter 4: Essentials of Spreadsheet Application Development

Part II: Understanding Visual Basic for Applications
Chapter 5: Introducing Visual Basic for Applications
Chapter 6: VBA Programming Fundamentals
Chapter 7: Working with VBA Sub Procedures
Chapter 8: Creating Function Procedures
Chapter 9: VBA Programming Examples and Techniques

Part III: Working with UserForms
Chapter 10: Custom Dialog Box Alternatives
Chapter 11: Introducing UserForms
Chapter 12: UserForm Examples
Chapter 13: Advanced UserForm Techniques

Part IV: Advanced Programming Techniques
Chapter 14: Developing Excel Utilities with VBA
Chapter 15: Working with Pivot Tables
Chapter 16: Working with Charts
Chapter 17: Understanding Excel's Events
Chapter 18: Interacting with Other Applications
Chapter 19: Creating and Using Add-Ins

Part V: Developing Applications
Chapter 20: Working with the Ribbon
Chapter 21: Working with Shortcut Menus
Chapter 22: Providing Help for Your Applications
Chapter 23: Developing User-Oriented Applications

Part VI: Other Topics
Chapter 24: Compatibility Issues
Chapter 25: Manipulating Files with VBA
Chapter 26: Manipulating Visual Basic Components
Chapter 27: Understanding Class Modules
Chapter 28: Working with Colors
Chapter 29: Frequently Asked Questions about Excel Programming

Part VII: Appendixes
Appendix A: VBA Statements and Functions Reference
Appendix B: VBA Error Codes
Appendix C: This Book's Website
Index

Language : English

Place of publishing : TORONTO

Location : Nice Library

Material : Electronic

Statement : Présent

Owner : Bibliothèque