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, 1972- (Author), Kusleika, Dick (Author)
Format Electronic eBook
LanguageEnglish
Published Indianapolis, IN : John Wiley & Sons, Inc., 2016.
SeriesMr. Spreadsheet's bookshelf.
Subjects
Microsoft Excel (Computer file)
Visual Basic for Applications (Computer program language)
Visual programming (Computer science)
Business > Computer programs.
Electronic spreadsheets.
elektronické knihy
electronic books
Online AccessFull text
ISBN9781119415503
1119415500
9781119067566
1119067561
9781119067627
1119067626
9781523114818
1523114819
9781119067726
1119067723
Physical Description1 online resource

Cover

Table of Contents:
  • 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.

Similar Items