Objects that were added to Visual Basic in Microsoft Excel 97 are listed in the following table. For more information about the changes to the Microsoft Excel 97 object model, see one of the following topics:
New Properties and Methods (by Object)
New Properties and Methods (Alphabetic List)
Changes to Visual Basic in Microsoft Excel for Windows 95
| Objects | Description |
|---|---|
| CalculatedFields, CalculatedItems | New PivotTable report functionality |
| Comment, Comments | New comment functionality; replaces cell notes |
| ControlFormat, LinkFormat, OLEFormat | Expose old Microsoft Excel controls and OLE objects in the Shapes collection |
| CustomView, CustomViews | New custom view feature |
| DataTable | Chart data table |
| ChartFillFormat, FillFormat | Chart and shape fill formatting |
| FormatCondition, FormatConditions | New conditional format feature |
| HPageBreak, HPageBreaks, VPageBreak, VPageBreaks | New horizontal and vertical page break features |
| Hyperlink, HyperLinks | Range and shape hyperlinks |
| LeaderLines | Chart leader lines that connect data labels to points |
| ODBCError, ODBCErrors, Parameter, Parameters, QueryTable, QueryTables, | New parameterized query features |
| PivotCache, PivotCaches, PivotFormula, PivotFormulas | New PivotTable report features |
| RecentFile, RecentFiles | List of recently used files |
| Adjustments, CalloutFormat, ChartColorFormat, ColorFormat, ConnectorFormat, FreeformBuilder, GroupShapes, LineFormat, PictureFormat, ShadowFormat, Shape, ShapeNode, ShapeNodes, Shapes, TextEfectFormat, TextFrame, ThreeDFormat | New drawing layer and chart fill |
| Validation | Range data validation |