Type Property

See Also         Example         Applies To

Returns or sets the object type, as shown in the following table.

Object Type
Axis Axis type. Can be one of the following XlAxisType constants: xlCategory, xlSeriesAxis, or xlValue. Read/write Long.
Color Color type. Can be one of the following MsoColorType constants: msoColorTypeMixed, msoColorTypeRGB, or msoColorTypeScheme. Read-only Long.
ConnectorFormat Connector type. Can be one of the following MsoConnectorType constants: msoConnectorCurve, msoConnectorElbow, msoConnectorStraight, or msoConnectorTypeMixed. Read/write Long.
DataLabel, DataLabels Data label type. Can be one of the following XlDataLabelsType constants: xlDataLabelsShowBubbleSizes, xlDataLabelsShowLabel, xlDataLabelsShowLabelAndPercent, xlDataLabelsShowNone, xlDataLabelsShowPercent, or xlDataLabelsShowValue. Read/write Long.
FillFormat Fill type. Can be one of the following MsoFillType constants: msoFillBackground, msoFillGradient, msoFillMixed, msoFillPatterned, msoFillPicture, msoFillSolid, or msoFillTextured. The msoFillBackground constant is not used in Microsoft Excel. Read-only Long.
FormatCondition Conditional format type. Can be one of the following xlFormatConditionType constants: xlCellValue or xlExpression. Read-only Long.
HPageBreak, VPageBreak Page break type. Can be one of the following XlPageBreak constants: xlPageBreakAutomatic or xlPageBreakManual. Read/write Long.
Hyperlink Hyperlink type (what the hyperlink is associated with). Can be one of the following MsoHyperlinkType constants: msoHyperlinkInlineShape, msoHyperlinkRange, or msoHyperlinkShape. Read-only Long.
Parameter Parameter type. Can be one of the following XlParameterType constants: xlConstant, xlPrompt, or xlRange. Read/write Long.
Shape, ShapeRange Shape type. Can be one of the following MsoShapeType constants: msoAutoShape, msoCallout, msoChart, msoComment, msoEmbeddedOLEObject, msoFormControl, msoFreeform, msoGroup, msoLine, msoLinkedOLEObject, msoLinkedPicture, msoMedia, msoOLEControlObject, msoPicture, msoPlaceholder, msoShapeTypeMixed, or msoTextEffect. Read-only Long. In Microsoft Excel, this property cannot be msoMedia or msoPlaceholder (these constants are used with shapes in other Microsoft Office applications)..
Trendline Trendline type. Can be one of the following XlTrendlineType constants: xlExponential, xlLinear, xlLogarithmic, xlMovingAvg, xlPolynomial, or xlPower. Read/write Long.
Validation Data validation type. Can be one of the following XlDVType constants: xlValidateCustom, xlValidateDate, xlValidateDecimal, xlValidateInputOnly, xlValidateList, xlValidateTextLength, xlValidateTime, or xlValidateWholeNumber. Read-only Long.
Window Window type. Can be one of the following XlWindowType constants: xlChartAsWindow, xlChartInPlace, xlClipboard, xlInfo, or xlWorkbook. Read-only Long.
Worksheet Worksheet type. Can be one of xlWorksheet, xlExcel4MacroSheet, or xlExcel4IntlMacroSheet. Read-only Long.