NLU Meghalaya Library

Online Public Access Catalogue (OPAC)

Excel 2016 Power Programming with VBA.

Alexander, Michael, 1972-

Excel 2016 Power Programming with VBA. - 1 online resource - Mr. Spreadsheet's Bookshelf . - Mr. Spreadsheet's bookshelf. .

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.

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

9781119415503 1119415500 9781119067566 1119067561 9781119067627 1119067626 9781523114818 1523114819

5201F529-26AE-444C-92CF-A2F9DFF27BCD OverDrive, Inc. http://www.overdrive.com

GBB621852 bnb

017738786 Uk


Microsoft Excel (Computer file)
Microsoft Excel (Computer file)


Visual Basic for Applications (Computer program language)
Visual programming (Computer science)
Business--Computer programs.
Electronic spreadsheets.
Programmation visuelle.
Tableurs.
COMPUTERS--Desktop Applications--Spreadsheets.
Business--Computer programs
Electronic spreadsheets
Visual Basic for Applications (Computer program language)
Visual programming (Computer science)
Excel 2016
VisualBASIC f�ur Applikationen

HF5548.4.M523

005.54