TY - BOOK AU - Alexander,Michael AU - Kusleika,Dick TI - Excel 2016 Power Programming with VBA T2 - Mr. Spreadsheet's Bookshelf SN - 9781119415503 AV - HF5548.4.M523 U1 - 005.54 23 PY - 2016/// CY - Indianapolis, IN PB - John Wiley & Sons, Inc. KW - Microsoft Excel (Computer file) KW - fast KW - Visual Basic for Applications (Computer program language) KW - Visual programming (Computer science) KW - Business KW - Computer programs KW - Electronic spreadsheets KW - Programmation visuelle KW - Tableurs KW - COMPUTERS KW - Desktop Applications KW - Spreadsheets KW - bisacsh KW - Excel 2016 KW - gnd KW - VisualBASIC f�ur Applikationen N1 - Includes bibliographical references and 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 N2 - 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. -- UR - https://onlinelibrary.wiley.com/doi/book/10.1002/9781119415503 ER -