Excel 2013 power programming with VBA /
Walkenbach, John
Excel 2013 power programming with VBA / Excel power programming with VBA Microsoft Excel 2013 power programming with VBA John Walkenbach. - Hoboken, New Jersey : Wiley, c2013. - xxvi, 1074 pages : illustrations ; 24 cm - Mr. Spreadsheet's bookshelf .
Includes index.
Part I: Some essential background -- Excel in a nutshell -- Formula tricks and techniques -- Understanding Excel files -- Essentials of spreadsheet application development -- Part II: Understanding Visual Basic for applications -- Introducing Visual Basic for applications -- VBS programming fundamentals -- Working with VBA subprocedures -- Creating function procedures -- VBA programming examples and techniques -- Part III: Working with UserForms -- Custom dialog box alternatives -- Introducing UserForms -- UserForm examples -- Advanced UserForm techniques -- Part IV: Advanced programing techniques -- Developing Excel utilities with VBA -- Working with Pivot tables -- Working with charts -- Understanding Excel's events -- Interacting with other applications -- Creating and using add ins -- Part V: Developing applications -- Working with the ribbon -- Working with shortcut menus -- Providing help for your applications -- Developing user-oriented applications -- Part VI: Other topics -- Compatibility issues -- Manipulating files with VBA -- Manipulating Visual Basic components -- Understanding class modules -- Working with colors -- Frequently asked questions about Excel programming -- Part VII: Appendixes -- Appendix A: VBA statements and functions reference -- Appendix B: VBA error codes -- Appendix C: This book's website.
"Presents information on using Microsoft's Visual Basic for Applications (VBA) programming language to customize Excel with UserForms, PivotTables, and user-oriented applications"-- Provided by publisher.
9781118490396 (paperback) 1118490398 (paperback)
Microsoft Excel (Computer file)
Microsoft Visual Basic for applications
Business--Computer programs
Electronic spreadsheets--Computer programs
Visual programming (Computer science)
HF5548.2 / W15 2013
Excel 2013 power programming with VBA / Excel power programming with VBA Microsoft Excel 2013 power programming with VBA John Walkenbach. - Hoboken, New Jersey : Wiley, c2013. - xxvi, 1074 pages : illustrations ; 24 cm - Mr. Spreadsheet's bookshelf .
Includes index.
Part I: Some essential background -- Excel in a nutshell -- Formula tricks and techniques -- Understanding Excel files -- Essentials of spreadsheet application development -- Part II: Understanding Visual Basic for applications -- Introducing Visual Basic for applications -- VBS programming fundamentals -- Working with VBA subprocedures -- Creating function procedures -- VBA programming examples and techniques -- Part III: Working with UserForms -- Custom dialog box alternatives -- Introducing UserForms -- UserForm examples -- Advanced UserForm techniques -- Part IV: Advanced programing techniques -- Developing Excel utilities with VBA -- Working with Pivot tables -- Working with charts -- Understanding Excel's events -- Interacting with other applications -- Creating and using add ins -- Part V: Developing applications -- Working with the ribbon -- Working with shortcut menus -- Providing help for your applications -- Developing user-oriented applications -- Part VI: Other topics -- Compatibility issues -- Manipulating files with VBA -- Manipulating Visual Basic components -- Understanding class modules -- Working with colors -- Frequently asked questions about Excel programming -- Part VII: Appendixes -- Appendix A: VBA statements and functions reference -- Appendix B: VBA error codes -- Appendix C: This book's website.
"Presents information on using Microsoft's Visual Basic for Applications (VBA) programming language to customize Excel with UserForms, PivotTables, and user-oriented applications"-- Provided by publisher.
9781118490396 (paperback) 1118490398 (paperback)
Microsoft Excel (Computer file)
Microsoft Visual Basic for applications
Business--Computer programs
Electronic spreadsheets--Computer programs
Visual programming (Computer science)
HF5548.2 / W15 2013