Chargement en cours…

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....

Description complète

Détails bibliographiques
Cote:Libro Electrónico
Auteurs principaux: Alexander, Michael, 1972- (Auteur), Kusleika, Dick (Auteur)
Format: Électronique eBook
Langue:Inglés
Publié: Indianapolis, IN : John Wiley & Sons, Inc., 2016.
Collection:Mr. Spreadsheet's bookshelf.
Sujets:
Accès en ligne:Texto completo
Table des matières:
  • 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.