|axxxviii, 1061 p. :|bill. ;|c24 cm. +|e1 CD-ROM (4 3/4 in.)
440
0
|aMr. Spreadsheet's bookshelf
500
|aIncludes index.
505
0
|aPart I: Some essential background -- Excel 2007: where it came from -- Excel in a nutshell -- Formula tricks and techniques -- Understanding Excel's files -- Part II: Excel application development -- What is a spreadsheet application? -- Essentials of spreadsheet application development -- Part III: Understanding visual basic for applications -- Introducing visual basic for applications -- VBA programming fundamentals -- Working with VBA sub procedures -- Creating function procedures -- VBA programming examples and techniques -- Part IV: Working with userforms -- Custom dialog box alternatives -- Introducing userforms -- Userform examples -- Advanced userform techniques -- Part V: Advanced programming 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 VI: Developing applications -- Workin with the ribbon -- Working with shortcut menus -- Providing help for your applications -- Developing user-oriented applications -- Part VII: Other topics -- Compatability issues -- Manipulating files with VBA -- Manipulating visual basic components -- Understanding class modules -- Working with colors -- Frequently asked questions about Excel programming -- Part VIII: Appendixes -- Appendix A: Excel resources online -- Appendix B: VBA statements and functions references -- Appendix C: VBA error codes -- Appendix D: What's on the CD-ROM.