• Table of Contents
• BackCover
• Definitive Guide to Excel VBA, Second Edition
• Preface
  • Excel and .NET
  • Why This Book?
  • Enjoy!
• The Idea Behind This Book
  • The Example Files
  • Excel XP or Excel 2002? Office XP or Office 2002?
• Part One: An Intuitive Approach
  • Chapter 1: Writing Your First Macro
    • 1.2 What Is Visual Basic for Applications?
    • 1.3 Linking a Custom Style with a Tool
    • 1.4 A Macro for Simplifying Input
    • 1.5 A Simple Literature Database
    • 1.6 A Form for Computing Interest in a Savings Account
    • 1.7 User-Defined Functions
    • 1.8 Analysis of Complex Tables
    • 1.9 A Vocabulary Tutor
    • 1.10 Example Programs for You to Try
  • Chapter 2: What's New in Excel 2000
    • 2.2 New in Excel 2000
    • 2.4 New in Excel 7
    • 2.5 Problems and Incompatibilities
• Part Two: Fundamentals
  • Chapter 3: The Development Environment
    • 3.2 The Components of the Development Environment
    • 3.3 Code Input in Modules
    • 3.4 Executing Macros
    • 3.5 Recording Macros
    • 3.6 Keyboard Shortcuts
  • Chapter 4: VBA Concepts
    • 4.2 Procedural Programming
    • 4.3 Objects
    • 4.4 Events
    • 4.5 Programming Your Own Classes
    • 4.6 Operators in VBA
    • 4.7 Virus Protection
  • Chapter 5: Techniques of Programming
    • 5.2 Workbooks, Windows, and Worksheets
    • 5.3 Data Transfer via the Clipboard
    • 5.4 Working with Numbers and Character Strings
    • 5.5 Working with Dates and Times
    • 5.6 Working with Files; Text Import and Export
    • 5.7 User-Defined Worksheet Functions
    • 5.8 Protection Mechanisms
    • 5.9 Configuration Files, Custom Configuration
    • 5.10 Excel Meets the Euro
    • 5.11 Tips and Tricks
  • Chapter 6: Debugging, Protection When Errors Arise
    • 6.2 Error-Tolerant Behavior of Programs
    • 6.3 Response to Program Interrupts
    • 6.4 Syntax Summary
  • Chapter 7: Forms (Microsoft Forms Library)
    • 7.2 User-Defined Forms
    • 7.3 The Form Editor
    • 7.4 The MS Forms Controls
    • 7.5 Placing Controls Directly into Worksheets
    • 7.6 Programming Techniques
  • Chapter 8: Menus and Toolbars
    • 8.2 Formatting the Interface for Freestanding Excel Applications
• Part Three: Application
  • Chapter 9: Templates, Smart Forms
    • 9.1 Fundamentals
    • 9.2 Example: The  " Speedy "  Invoice Form
    • 9.3 Example: Balance Sheet for a Car-Sharing Club
    • 9.4 The Limits of  " Smart Forms "
  • Chapter 10: Charts and Drawing Objects (Shapes)
    • 10.2 Programming Charts
    • 10.3 Example: Automatic Data Reporting
    • 10.4 Syntax Summary for Charts
    • 10.5 Drawing Objects (Shapes)
    • 10.6 Diagrams
  • Chapter 11: Data Management in Excel
    • 11.1 Fundamentals
    • 11.2 Data Management Within Excel
    • 11.3 Data Processing in VBA Code
    • 11.4 Database Worksheet Functions
    • 11.5 Consolidating Tables
    • 11.6 Example: Balance Sheet for a Car-Sharing Club
  • Chapter 12: Access to External Data
    • 12.2 Importing External Data
    • 12.3 Database Access with the ADO Library
    • 12.4 Example: Evaluating a Questionnaire
  • Chapter 13: Data Analysis in Excel
    • 13.2 Pivot Tables
    • 13.3 Programming Techniques
  • Chapter 14: VBA Programming for Pros
    • 14.2 Excel and the Internet
    • 14.3 Smart Tags
    • 14.4 Using Web Services
    • 14.5 Using Dynamic Link Libraries (DLLs)
    • 14.6 ActiveX Automation
• Part Four: Reference
  • Chapter 15: Object Reference
    • 15.2 Alphabetical Reference
• Appendix: Excel 2003 Beta 2
  • What's New in Excel 2003
  • Office 2003 and .NET
  • List Processing
  • Excel 2003 and XML (Extensible Markup Language)
  • XML Programming
  • Object Reference
• References
• Index
  • Index_Numbers
  • Index_A
  • Index_B
  • Index_C
  • Index_D
  • Index_E
  • Index_F
  • Index_G
  • Index_H
  • Index_I
  • Index_J
  • Index_K
  • Index_L
  • Index_M
  • Index_N
  • Index_O
  • Index_P
  • Index_Q
  • Index_R
  • Index_S
  • Index_T
  • Index_U
  • Index_V
  • Index_W
  • Index_X
  • Index_Y
  • Index_Z
• List of Figures