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

Full description

Saved in:
Bibliographic Details
Main Authors: Alexander, Michael (Author), Kusleika, Dick (Author)
Format: Electronic eBook
Language:English
Published: 2016
Series:Mr. Spreadsheet's bookshelf
Subjects:
Online Access:FHA01
FHR01
FR001
UBG01
UBT01
UBY01
UER01
Volltext
Summary: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. --
Item Description:Includes index
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
Includes bibliographical references
Physical Description:1 Online-Ressource (1 online resource)
ISBN:9781119415503
9781119067566
9781119067627

There is no print copy available.

Interlibrary loan Place Request Caution: Not in THWS collection! Get full text