Temporarily Out of Stock Online
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.
About the Author
Reed Jacobson owns Jacobson GeniusWorks, a company that specializes in creative training, consulting, and custom development services for Microsoft® Excel and other Microsoft Office products. Jacobson GeniusWorks is one of the original partner companies in the Microsoft Excel Consulting Relations Program.
Reed has received a B.A. in Japanese and linguistics, an M.B.A. from Brigham Young University, and a graduate fellowship in linguistics from Cornell University. He worked as a Software Application Specialist for Hewlett-Packard for ten years. Reed is also the author of Excel Trade Secrets for Windows® and has given presentations on Excel at TechEd and other Microsoft conferences and seminars.
Send e-mail to email@example.com
Table of Contents
|Finding Your Best Starting Point|
|Installing the Practice Files and Additional Microsoft Excel Tools|
|Conventions and Features Used in This Book|
|Lesson 1||Make a Macro Do Simple Tasks||3|
|Lesson 2||Make a Macro Do Complex Tasks||25|
|Lesson 3||Explore Microsoft Excel's Object Library||55|
|Lesson 4||Explore Range Objects||89|
|Lesson 5||Explore Graphical Objects||115|
|Lesson 6||Explore PivotTable Objects||137|
|Lesson 7||Controlling Visual Basic||157|
|Lesson 8||Extending Microsoft Excel and Visual Basic||181|
|Lesson 9||Launching Macros with Events||205|
|Lesson 10||Using Dialog Box Controls on a Worksheet||233|
|Lesson 11||Creating a Custom Form||251|
|Lesson 12||Creating an Enterprise Information System||281|
|App. A||Alternative Techniques||323|
|App. B||Checking Your Configuration||329|