Excel 2016 Power Programming with VBA

✍ Scribed by Alexander, Michael; Kusleika, Dick

• Publisher: John Wiley & Sons
• Year: 2016
• Tongue: English
• Leaves: 743
• Series: Mr. Spreadsheet's bookshelf
• Category: Library

✦ Synopsis

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

Abstract:

Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Read more...

✦ Table of Contents

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

✦ Subjects

Microsoft Excel (Computer file);COMPUTERS -- Desktop Applications -- Spreadsheets;Visual Basic for Applications (Computer program language);Visual programming (Computer science);Business -- Computer programs;Electronic spreadsheets;Excel 2016;VisualBASIC für Applikationen