Excel 2000 Visual Basic for Applications

Microsoft(r) Excel 2000 Visual Basic(r) Fundamentals, is the teach-yourself guide to using the Excel macro language to take control of Excel. You'll learn to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, connect applications to the Internet, and more.

The easy-to-follow lessons include clear objectives and real-world business examples so you can learn exactly what you need to know, at your own speed. Prepared by an author with extensive knowledge of Visual Basice for Applications and Microsoft Excel, the new edition is expanded to include approximately fifteen hours of instruction in approximately 450 pages, with numerous screen shots and illustrations.

Contents

Part 1: Automating Everyday Tasks

Chapter 1: Make a Macro Do Simple Tasks ..... 5
Chapter 2: Make a Macro Do Complex Tasks ..... 27

Part 2: Exploring Objects

Chapter 3: Explore Microsoft Excel's Object Library ..... 61
Chapter 4: Explore Range Objects ..... 91
Chapter 5: Explore Graphical Objects ..... 113
Chapter 6: Explore PivotTable Objects ..... 133

Part 3: Exploring Visual Basic

Chapter 7: Controlling Visual Basic ..... 159
Chapter 8: Extending Excel and Visual Basic ..... 181

Part 4: Making Macros Easy to Use

Chapter 9: Launching Macros with Events ..... 209
Chapter 10: Using Dialog Box Controls on a Worksheet ..... 235
Chapter 11: Creating a Custom Form ..... 251
Chapter 12: Creating an Enterprise Information System ..... 279

Part 5: Appendixes

Appendix A: Alternative Techniques ..... 327
Appendix B: Checking Your Configuration ..... 335

Excel Environment ..... 335
Visual Basic Editor Environment ..... 337
Index ..... 339