Excel 2002 power programming with VBA / John Walkenbach.
By: Walkenbach, John.
Series: Professional mindware.Publisher: New York : M&T Books, c2001Description: xxxviii, 934 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.).ISBN: 0764547992 (pbk.).Subject(s): Microsoft Excel (Computer file) | Microsoft Visual BASIC | Computer software -- Development | Electronic spreadsheetsDDC classification: 005.369Item type | Current location | Call number | Vol info | Copy number | Status | Notes | Date due | Barcode | Remark |
---|---|---|---|---|---|---|---|---|---|
Accompanying Material (Media Resource) | TU External Storage-LCS | 005.369 WAL (Browse shelf) | CD-ROM | 1 | Available | SOCIT,15008,03,GR | 1000117714 | Please fill up online form at https://taylorslibrary.taylors.edu.my/services/external_storage1 |
Includes index.
Preface. - Acknowledgments. - Pt. I. Some essential background. Ch. 1. Excel 2002 : where it came from. Ch. 2. Excel in a Nutshell. Ch. 3. Formula tricks and techniques. Ch. 4. Understanding Excel's files. - Pt. II. Excel application development. Ch. 5. What is a spreadsheet application? Ch. 6. Essentials of spreadsheet application development. - Pt. III. Understanding Visual Basic for applications. Ch. 7. Introducing Visual Basic for appllication. Ch. 8. VBA programming fundamentals. Ch. 9. Working with VBA sub procedures. Ch. 10. Creating function procedures. Ch. 11. VBA programming examples and techniques. - Pt. IV. Working with userforms. Ch. 12. Custom dialog box alternatives. Ch 13. Introducing userforms. Ch. 14. Userform examples. Ch. 15. Advanced userform techniques. - Pt. V. Advanced programming techniques. Ch. 16. Developing excel utilities with VBA. Ch. 17. Working with Pivot tables. Ch. 18. Working with charts. Ch. 19. Understanding Excel's events. Ch. 20. Interacting with other applications. Ch. 21. Creating and using add-ins. - Pt. VI. Developing applications. Ch. 22. Creating custom toolbars. Ch. 23. Creating custom menus. Ch. 24. Providing help for your applications. Ch. 25. Developing user-oriented applications. - Pt. VII. Other topics. Ch. 26. Compability issues. Ch. 27. Manipulating files with VBA. Ch. 28. Manipulating Visual Basic components. Ch. 29. Understanding class modules. Ch. 30. Frequently asked questions and Excel programming. - Index. - End-user licence agreement.