• ▼MSDN Library Visual Studio 6.0
  • ▶Welcome to the MSDN Library
  • ▶Visual Studio Documentation
  • ▶Visual Basic Documentation
  • ▶Visual C++ Documentation
  • ▶Visual FoxPro Documentation
  • ▶Visual InterDev Documentation
  • ▶Visual J++ Documentation
  • ▶Visual SourceSafe Documentation
  • ▶Tools and Technologies
  • ▼Microsoft Office Development
    • ▶Office 97 Documentation
    • ▼Office 95 Documentation
      • ▶Access
      • ▼Excel
        • ▶Microsoft Excel Developer's Kit for Windows 95
        • ▼Microsoft Excel/Visual Basic Programmer's Guide
          • Introduction
          • ▶Getting Started
          • Tips on How to Learn Visual Basic
          • How This Book Is Organized
          • Code Samples
          • Using Online Help
          • Document Conventions
          • Programming Style
          • Microsoft Product Support Services
          • ▶Chapter 1 Modules and Procedures
          • ▶Chapter 2 Variables, Constants,and Data Types
          • ▶Chapter 3 Controlling Program Flow
          • ▶Chapter 4 Objects and Collections
          • ▼Chapter 5 Optimizing for Size and Speed
            • ▼Minimizing OLE References
              • Using Object Variables
              • Using the With Statement
              • Using a For Each...Next Loop
              • Keeping Properties and Methods Outside Loops
              • Using Arrays to Specify Multiple Objects
            • Using Collection Index Numbers
            • Minimizing Object Activation and Selection
            • Removing Unnecessary Recorded Expressions
            • Minimizing the Use of Variant Variables
            • Using Specific Object Types
            • Using Constants
            • Using Worksheet Functions
            • Using Special-Purpose Visual Basic Methods
            • Turning Off Screen Updating
          • ▶Chapter 6 Debugging
          • ▶Chapter 7 Handling Run-Time Errors
          • ▶Chapter 8 Controls and Dialog Boxes
          • ▶Chapter 9 Menus and Toolbars
          • ▶Chapter 10 Communicating with Other Applications
          • ▶Chapter 11 Automatic Procedures and OnEvent Procedures
          • ▶Chapter 12 Creating Add-Ins
          • ▶Chapter 13 Accessing External Data
          • ▶Appendix A Writing Code for International Use
          • ▶Appendix B Switching from the Microsoft Excel 4.0 Macro Language
          • ▶Appendix C Toolbar Buttons in Microsoft Excel
          • Appendix D Microsoft Excel Object Model Graphics
        • ▶Microsoft Excel/Visual Basic Reference
        • ▶XLM Macro Function Help
        • ▶Developing Excel 95 Solutions with Visual Basic for Applications
        • ▶Constructing a VBA Wizard
      • ▶Office
      • ▶Project
      • ▶Word
  • ▶Platform SDK
  • ▶SDK Documentation
  • ▶DDK Documentation
  • ▶Windows Resource Kits
  • ▶Specifications
  • ▶Knowledge Base
  • ▶Technical Articles
  • ▶Backgrounders
  • ▶Books
  • ▶Partial Books
  • ▶Periodicals
  • ▶Conference Papers