List of Tables

 < Day Day Up > 



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



 < Day Day Up > 



Microsoft Excel 2003 Programming Inside Out
Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
ISBN: 0735619859
EAN: 2147483647
Year: 2006
Pages: 161

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net