Excel® 2019 power programming with VBA /

Maximize your Excel experience with VBA Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Alexander, Michael (Autor), Kusleika, Dick (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, IN : Wiley, 2019.
Temas:
Microsoft Excel (Computer file)
Visual Basic for Applications (Computer program language)
COMPUTERS > Desktop Applications > Spreadsheets.
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
  • Looking at UserForm Examples
  • Implementing 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 Functions Reference.

Ejemplares similares