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. |