Excel 2013 power programming with VBA / John Walkenbach.
Material type:
TextLanguage: English Series: Mr. Spreadsheet's bookshelfPublication details: Hoboken, New Jersey : Wiley, c2013.Description: xxvi, 1074 pages : illustrations ; 24 cmContent type: - text
- unmediated
- volume
- 9781118490396 (paperback)
- 1118490398 (paperback)
- Excel power programming with VBA
- Microsoft Excel 2013 power programming with VBA
- HF5548.2 W15 2013
| Item type | Current library | Collection | Call number | Materials specified | Status | Notes | Date due | Barcode |
|---|---|---|---|---|---|---|---|---|
Books
|
Ladislao N. Diwa Memorial Library Reserve Section | Non-fiction | RUS HF5548.2 W15 2013 (Browse shelf(Opens below)) | Room use only | 76358 | 00077932 |
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.
Fund 164 Creative Mind Books Center Purchased 10/05/2017 76358 NEJ PHP 4,437.00 2017-09-0991 2017-1-0738