Type Property [Excel 2003 VBA Language Reference]
Type property as it applies to the Axis object.
XlAxisType
XlAxisType can be one of these XlAxisType constants. |
xlCategory |
xlSeriesAxis |
xlValue |
expression.Type
expression Required. An expression that returns an Axis object.
Remarks
When using this property for the horizontal axis of scatter charts, xlCategory will be returned as the Axis type.
Type property as it applies to the CalculatedMember object.
XlCalculatedMemberType
XlCalculatedMemberType can be one of these XlCalculatedMemberType constants. |
xlCalculatedMember |
xlCalculatedSet |
expression.Type
expression Required. An expression that returns a CalculatedMember object.
Type property as it applies to the CalloutFormat object.
MsoCalloutType
MsoCalloutType can be one of these MsoCalloutType constants. |
msoCalloutFour |
msoCalloutMixed |
msoCalloutOne |
msoCalloutThree |
msoCalloutTwo |
expression.Type
expression Required. An expression that returns a CalloutFormat object.
Type property as it applies to the ChartGroup and Series objects.
Returns or sets the chart group or series type. Read/write Long.
The following constants can be used for this property. |
xlColumn |
xlBar |
xl3DBar |
xlLine |
xlPie |
xlXYScatter |
xlArea |
xl3DArea |
xlDoughnut |
xlRadar |
xl3DSurface |
xl3DColumn |
xl3DBar |
expression.Type
expression Required. An expression that returns one of the above objects.
Type property as it applies to the ChartColorFormat object.
Returns whether the color is and RGB or scheme type. Read-only Long that can be one of the following values of the MsoColorType: msoColorTypeRGB or msoColorTypeScheme.
expression.Type
expression Required. An expression that returns a ChartColorFormat object.
Type property as it applies to the ChartFillFormat and FillFormat objects.
MsoFillType
MsoFillType can be one of these constants. |
msoFillBackground This constant is not used in Microsoft Excel. |
msoFillGradient |
msoFillMixed |
msoFillPatterned |
msoFillPicture |
msoFillSolid |
msoFillTextured |
expression.Type
expression Required. An expression that returns one of the above objects.
Type property as it applies to the ColorFormat object.
MsoColorType
MsoColorType can be one of these MsoColorType constants. |
msoColorTypeCMS |
msoColorTypeCMYK |
msoColorTypeInk |
msoColorTypeMixed |
msoColorTypeRGB |
msoColorTypeScheme |
expression.Type
expression Required. An expression that returns a ColorFormat object.
Type property as it applies to the ConnectorFormat object.
MsoConnectorType
MsoConnectorType can be one of these MsoConnectorType constants. |
msoConnectorCurve |
msoConnectorElbow |
msoConnectorStraight |
msoConnectorTypeMixed |
expression.Type
expression Required. An expression that returns a ConnectorFormat object.
Type property as it applies to the DataLabel and DataLabels objects.
Returns or sets the label type. Read/write Variant.
The following constants of XlDataLabelsType are used for this property. |
xlDataLabelsShowBubbleSizes |
xlDataLabelsShowLabel |
xlDataLabelsShowLabelAndPercent |
xlDataLabelsShowNone |
xlDataLabelsShowPercent |
xlDataLabelsShowValue |
expression.Type
expression Required. An expression that returns one of the above objects.
Type property as it applies to the Diagram object.
MsoDiagramType
MsoDiagramType can be one of these MsoDiagramType constants. |
msoDiagramCycle |
msoDiagramMixed |
msoDiagramOrgChart |
msoDiagramPyramid |
msoDiagramRadial |
msoDiagramTarget |
msoDiagramVenn |
expression.Type
expression Required. An expression that returns a Diagram object.
Type property as it applies to the FormatCondition object.
xlFormatConditionType
The return type can be one of these XlFormatConditionType constants. |
xlCellValue |
xlExpression |
expression.Type
expression Required. An expression that returns a FormatCondition object.
Type property as it applies to the HPageBreak and VPageBreak objects.
XlPageBreak
XlPageBreak can be one of these XlPageBreak constants. |
xlPageBreakAutomatic |
xlPageBreakManual |
xlPageBreakNone |
expression.Type
expression Required. An expression that returns one of the above objects.
Type property as it applies to the Hyperlink object.
Returns the location of the HTML frame. Read-only Long which can be one of the following constants of msoHyperlinkType: msoHyperlinkInlineShape, msoHyperlinkRange, or msoHyperlinkShape.
expression.Type
expression Required. An expression that returns a Hyperlink object.
Type property as it applies to the ListDataFormat object.
XlListDataType
XlListDataType can be one of these XlListDataType constants. |
xlListDataTypeNone |
xlListDataTypeText |
xlListDataTypeMultiLineText |
xlListDataTypeMultiLineRichText |
xlListDataTypeCounter |
xlListDataTypeNumber |
xlListDataTypeCurrency |
xlListDataTypeDateTime |
xlListDataTypeChoice |
xlListDataTypeChoiceMulti |
xlListDataTypeListLookup |
xlListDataTypeCheckbox |
xlListDataTypeHyperLink |
This property is used only for lists that are linked to a SharePoint site.
expression.Type
expression Required. An expression that returns a ListDataFormat object.
Type property as it applies to the Parameter object.
XlParameterType
XlParameterType can be one of these XlParameterType constants. |
xlConstant |
xlPrompt |
xlRange |
expression.Type
expression Required. An expression that returns a Parameter object.
Type property as it applies to the ShadowFormat object.
MsoShadowType
MsoShadowType can be one of these MsoShadowType constants. |
msoShadow1 |
msoShadow10 |
msoShadow11 |
msoShadow12 |
msoShadow13 |
msoShadow14 |
msoShadow15 |
msoShadow16 |
msoShadow17 |
msoShadow18 |
msoShadow19 |
msoShadow2 |
msoShadow20 |
msoShadow3 |
msoShadow4 |
msoShadow5 |
msoShadow6 |
msoShadow7 |
msoShadow8 |
msoShadow9 |
msoShadowMixed |
expression.Type
expression Required. An expression that returns a ShadowFormat object.
Type property as it applies to the Shape and ShapeRange objects.
MsoShapeType
MsoShapeType can be one of these MsoShapeType constants. |
msoAutoShape |
msoCallout |
msoCanvas |
msoChart |
msoComment |
msoDiagram |
msoEmbeddedOLEObject |
msoFormControl |
msoFreeform |
msoGroup |
msoLine |
msoLinkedOLEObject |
msoLinkedPicture |
msoMedia Can not be used with this property. This constant is used with shapes in other Microsoft Office applications. |
msoOLEControlObject |
msoPicture |
msoPlaceholder Can not be used with this property. This constant is used with shapes in other Microsoft Office applications. |
msoScriptAnchor |
msoShapeTypeMixed |
msoTable |
msoTextBox |
msoTextEffect |
expression.Type
expression Required. An expression that returns one of the above objects.
Type property as it applies to the SmartTagAction object.
XlSmartTagControlType
XlSmartTagControlType can be one of these XlSmartTagControlType constants. |
xlSmartTagControlActiveX |
xlSmartTagControlButton |
xlSmartTagControlCheckbox |
xlSmartTagControlCombo |
xlSmartTagControlHelp |
xlSmartTagControlHelpURL |
xlSmartTagControlImage |
xlSmartTagControlLabel |
xlSmartTagControlLink |
xlSmartTagControlListbox |
xlSmartTagControlRadioGroup |
xlSmartTagControlSeparator |
xlSmartTagControlSmartTag |
xlSmartTagControlTextbox |
expression.Type
expression Required. An expression that returns a SmartTagAction object.
Type property as it applies to the Trendline object.
XlTrendlineType
XlTrendlineType can be one of these XlTrendlineType constants. |
xlExponential |
xlLinear |
xlLogarithmic |
xlMovingAvg |
xlPolynomial |
xlPower |
expression.Type
expression Required. An expression that returns a Trendline object.
Type property as it applies to the Validation object.
XlDVType
The return value can be one of these XlDVType constants |
xlValidateCustom |
xlValidateDate |
xlValidateDecimal |
xlValidateInputOnly |
xlValidateList |
xlValidateTextLength |
xlValidateTime |
xlValidateWholeNumber |
expression.Type
expression Required. An expression that returns a Validation object.
Type property as it applies to the Window object.
XlWindowType
XlWindowType can be one of these XlWindowType constants. |
xlChartAsWindow |
xlChartInPlace |
xlClipboard |
xlInfo |
xlWorkbook |
expression.Type
expression Required. An expression that returns a Window object.
Type property as it applies to the Worksheet object.
XlSheetType
XlSheetType can be one of these XlSheetType constants. |
xlChart |
xlDialogSheet |
xlExcel4IntlMacroSheet |
xlExcel4MacroSheet |
xlWorksheet |
expression.Type
expression Required. An expression that returns a Worksheet object.
Example
As it applies to the Trendline object.
This example changes the trendline type for the first series in embedded chart one on worksheet one. If the series has no trendline, this example fails.
Worksheets(1).ChartObjects(1).Chart _
.SeriesCollection(1).Trendlines(1).Type = xlMovingAvg
Applies to | Axis Object | CalculatedMember Object | CalloutFormat Object | ChartColorFormat Object | ChartFillFormat Object | ColorFormat Object | ConnectorFormat Object | DataLabel Object | DataLabels Collection Object | Diagram Object | FillFormat Object | FormatCondition Object | HPageBreak Object | Hyperlink Object | ListDataFormat Object | Parameter Object | Series Object | ShadowFormat Object | Shape Object | ShapeRange Collection | SmartTagAction Object | Trendline Object | Validation Object | VPageBreak Object | Window Object | Worksheet Object
See Also | ChartType Property