Excel 2016 Power Programming with VBA.
Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA) - with over 800 pages of tips, tricks, and best practices, this comprehensive book presents all of the techniques you need to develop both large and small Excel applications....
Clasificación: | Libro Electrónico |
---|---|
Autores principales: | , |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Indianapolis, IN :
John Wiley & Sons, Inc.,
2016.
|
Colección: | Mr. Spreadsheet's bookshelf.
|
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Introduction to Excel VBA. Essentials of Spreadsheet Application Development
- Introducing Visual Basic for Applications
- VBA Programming Fundamentals
- Working with VBA Sub Procedures
- Creating Function Procedures
- Understanding Excel's Events
- VBA Programming Examples and Techniques
- Advanced VBA Techniques. Working with Pivot Tables
- Working with Charts
- Interacting with Other Applications
- Working with External Data and Files
- Working with UserForms. Leveraging Custom Dialog Boxes
- Introducing UserForms
- UserForm Examples
- Advanced UserForm Techniques
- Developing Excel Applications. Creating and Using Add-Ins
- Working with the Ribbon
- Working with Shortcut Menus
- Providing Help for Your Applications
- Leveraging Class Modules
- Understanding Compatibility Issues
- Appendix. VBA Statements and Function.