Abstract:
|
Lesson 1. Make a Macro Do Simple Tasks -- Lesson 2. Make a Macro Do Complex Tasks -- Lesson 3. Explore Microsoft Excel's Object Library -- Lesson 4. Explore Range Objects -- Lesson 5. Explore Graphical Objects -- Lesson 6. Explore PivotTable Objects -- Lesson 7. Controlling Visual Basic -- Lesson 8. Extending Microsoft Excel and Visual Basic -- Lesson 9. Launching Macros with Events -- Lesson 10. Using Dialog Box Controls on a Worksheet -- Lesson 11. Creating a Custom Form -- Lesson 12. Creating an Enterp
With this book and Microsoft Excel 97, you'll learn to use Visual Basic for Applications to build a Microsoft Excel application with Visual Basic for Applications, create custom worksheet functions, extend the power of ranges and formulas, use Visual Basic tools, customize menus and toolbars, automate routine tasks, create presentation tools, and customize recorded macros.
|