Summary of Version Changes

In 1997, Excel Version 8.0 introduced object-oriented programming features including events and classes. User forms replaced dialog sheets, and pivot table objects were expanded. Forms 2.0 controls and the following objects were introduced:

Adjustments

CalculatedFields

CalculatedItems

CalloutFormat

ChartColorFormat

ChartFillFormat

ColorFormat

Comment

ControlFormat

CustomView

DataTable

FillFormat

FormatCondition

FreeformBuilder

GroupShapes

HPageBreak

Hyperlink

LeaderLines

LineFormat

ODBCError

OLEFormat

Parameter

PictureFormat

PivotCache

PivotField

PivotFormula

QueryTable

RecentFile

ShadowFormat

Shape

ShapeNode

ShapeRange

TextEffectFormat

TextFrame

ThreeDFormat

Validation

VPageBreak

  

In 2000, Excel Version 9.0 introduced Visual Basic Version 6.0 and made minor additions to the object model. Mainly, Version 9.0 added OLAP to pivot tables and enabled publishing to the Web. The following objects were introduced:

CubeField

DefaultWebOptions

DisplayUnitLabel

Filter

Floor

Font

OLEDBError

Phonetic

PivotLayout

PublishObject

WebOptions

 

In 2002, Excel Version 10.0 added smart tags, worksheet errors and watches, speech, and edit ranges. The following objects were introduced:

AllowEditRange

AutoRecover

CalculatedMember

CellFormat

CustomProperty

Diagram

DiagramNodeChildren

Error

ErrorCheckingOptions

Graphic

PivotCell

PivotItemList

Protection

RTD

SmartTag

SmartTagAction

SmartTagOptions

SmartTagRecognizer ...

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.