List of Tables

---

Chapter 1: What's New in Excel 2003

Table 1-1: Improved Statistical Functions

Chapter 2: Exploring Excel

Table 2-1: Excel Worksheets Can Hold a Lot of Data but Have Their Limits

Chapter 3: Exploring Visual Basic for Applications

Table 3-1: Keyboard Shortcuts for Executing Macro Steps in the Visual Basic Editor

Table 3-2: How Excel Reacts to Various Digital Signature Scenarios When Macro Security Is Set to High

Chapter 4: VBA Programming Starter Kit

Table 4-1: Menu Items Available on the View Menu in the Visual Basic Editor

Table 4-2: Menu Items Available on the Insert Menu in the Visual Basic Editor

Table 4-3: Menu Items Available on the Format Menu in the Visual Basic Editor

Table 4-4: Menu Items Available on the Debug Menu in the Visual Basic Editor

Table 4-5: Menu Items Available on the Run Menu in the Visual Basic Editor

Table 4-6: Menu Items Available on the Tools Menu in the Visual Basic Editor

Table 4-7: Numeric Data Types

Table 4-8: Data Type Conversion Functions

Table 4-9: Button Options for Message Boxes

Table 4-10: Values Returned by a Message Box

Table 4-11: Comparison Operators

Chapter 5: Creating Sub and Function Procedures

Table 5-Elements: of a Sub Procedure:

Table 5-2: Elements of a Function Procedure

Chapter 6: The Application Object

Table 6-1: InputBox Type Values

Table 6-2: Cell Error Values

Table 6-3: Key Codes

Chapter 7: Workbooks and Worksheets

Table 7-1: The Parameters Associated with the Workbooks.Open Method_ (continued)

Table 7-2: Parameters Available with the Workbooks.OpenText Method

Table 7-3: The ThisWorkbook.SaveAs Parameters

Table 7-4: The Parameters of the FollowHyperlink Method

Table 7-5: The Parameters of the PrintOut Method

Table 7-6: Selected Properties of the PageSetup Object

Table 7-7: Parameters of the Worksheet.Protect Method

Chapter 8: Ranges and Cells

Table 8-1: Range Selection Methods

Table 8-2: xlSpecialCellsValue Constants

Table 8-3: Constants Used with the ConvertFormula Method

Table 8-4: The Properties and Methods of the Validation Object

Table 8-5: The List of Parameters Used in an Add or Modify Statement

Chapter 9: Manipulating Data with VBA

Table 9-1: The IS Family of Functions

Table 9-2: The Most Common Summary Calculations You'll Perform in Excel

Table 9-3: An In-Depth Look at the PMT Function's Arguments

Table 9-4: The Rate Function's Arguments

Table 9-5: Useful Functions for Finding All or Part of a Date or Time

Table 9-6: Codes for Intervals Used in the DateAdd Function

Table 9-7: The DateDiff Function's Arguments

Chapter 10: Formatting Excel Objects

Table 10-1: The RGB Values of the VBA Color Constants

Table 10-2: The RGB Values of the VBA Color Constants

Table 10-3: The RGB Values of the Standard Excel Colors

Table 10-4: The RGB Values of Standard HTML Colors

Table 10-5: Excel Palette Colors That Correspond to HTML Colors

Table 10-6: The Font Object's Properties

Table 10-7: The Interior Object's Properties for Formatting a Cell

Table 10-8: The Borders Object's Properties

Chapter 11: Creating Add-Ins and COM Add-Ins

Table 11-1: Add-Ins Supplied with Excel

Table 11-2: Properties

Table 11-3: AddIn Properties

Table 11-4: IDTExtensibility2 Interface Methods

Chapter 12: Understanding and Using Events

Table 12-1: Commonly Used Workbook Events

Table 12-2: Commonly Used Worksheet Events

Table 12-3: Commonly Monitored Events by the Application Object

Chapter 13: Manipulating Files

Table 13-1: List of Properties and Methods of the FileSearch Object

Table 13-2: List of File Types and Their Values

Table 13-3: List of LastModified Properties and Their Values

Table 13-4: List of msoSearchIn Properties and Their Values

Table 13-5: List of Dialog Types and Their Values

Chapter 15: Charts

Table 15-1: Components Contained Within the Chart

Table 15-2: Chart Location Properties

Table 15-3: Chart Properties

Table 15-4: ChartObject Properties

Chapter 16: PivotTables and PivotCharts

Table 16-1: Key Properties and Methods of the PivotTables Collection

Table 16-2: Key Properties and Methods of the PivotTable Object

Table 16-3: Key Properties and Methods of the PivotCaches Collection

Table 16-4: Key Properties and Methods of the PivotCache Object

Table 16-5: Key Properties and Methods of the PivotField Object

Table 16-6: Key Properties and Methods of the PivotItem Object

Table 16-7: Numerical Values of XlPivotFieldOrientation Constants

Chapter 17: Command Bars

Table 17-1: Key Properties and Methods of the CommandBars Collection

Table 17-2: Key Properties and Methods of the CommandBar Object

Table 17-3: Key Properties and Methods of the CommandBarControls Collection

Table 17-4: Command Bar Control Types

Table 17-5: Key Properties and Methods of the CommandBarControl Object

Table 17-6: Unique Properties and Methods of the CommandBarButton Object

Table 17-7: Unique Properties and Methods of the CommandBarComboBox Object

Table 17-8: Unique Properties of the CommandBarPopup Object

Chapter 18: Customizing Dialog Boxes

Table 18-1: xlDialog Boxes Used to Format Cells

Table 18-2: xlDialog Boxes Used to Modify Charts

Table 18-3: xlDialog Boxes Found in Excel's Menu Structure

Chapter 19: Creating User Forms

Table 19-1: Key Properties of the UserForm Object

Table 19-2: Key Properties, Methods, and Events of the UserForm Controls

Chapter 21: Excel and Other Office Applications

Table 21-1: Top-Level Office Objects and Their Associated Class Names

Table 21-2: Excel Objects and Their Functions

Chapter 22: Excel and the Structured Query Language

Table 22-1: Wildcard Characters in Access

Chapter 23: Introducing ADO

Table 23-1: Key Properties and Methods of the Connection Object

Table 23-2: Other OLE DB Data Providers

Table 23-3: Key Properties and Methods of the Errors Collection

Table 23-4: Key Properties of the Error Object

Table 23-5: Key Properties and Methods of the Command Object

Table 23-6: Properties and Methods of the Parameters Collection

Table 23-7: Key Properties of the Parameter Object

Table 23-8: Key Properties and Methods of the Recordset Object

Table 23-9: Key Properties of the Fields Collection

Table 23-10: Key Properties of the Field Object

Chapter 25: Excel and the Web

Table 25-1: Interactivity Options

Chapter 26: Excel and the Extensible Markup Language (XML)

Table 26-1: Properties and Methods of the Object

Table 26-2: Arguments of the ListObjects Collection's Add Method

Table 26-3: Selected Properties and Methods of the XmlMap Object

Table 26-4: The XPath Object's Properties and Methods

---