Type Property

Microsoft Excel Visual Basic

Returns the Axis type. Read-only. XlAxisType.

XlAxisType can be one of these XlAxisType constants.
xlCategory
xlSeriesAxis
xlValue

expression.Type

expression    Required. An expression that returns an Axis object.

ShowType property as it applies to the CalculatedMember object.

Returns the calculated member type. Read-only XlCalculatedMemberType.

XlCalculatedMemberType can be one of these XlCalculatedMemberType constants.
xlCalculatedMember
xlCalculatedSet

expression.Type

expression    Required. An expression that returns a CalculatedMember object.

ShowType property as it applies to the CalloutFormat object.

Returns or sets the callout format type. Read/write 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.

ShowType property as it applies to the Chart, ChartGroup, and Series objects.

Returns or sets the chart or series type. Read/write Long.

expression.Type

expression    Required. An expression that returns one of the above objects.

ShowType property as it applies to the ChartColorFormat, FormatCondition, Hyperlink, and Validation objects.

Returns or sets the object type. Read-only Long.

expression.Type

expression    Required. An expression that returns one of the above objects.

ShowType property as it applies to the ChartFillFormat and FillFormat objects.

Returns or sets the the fill type. Read-only MsoFillType.

MsoFillType can be one of these MsoFillType 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.

ShowType property as it applies to the ColorFormat object.

Returns or sets the color format type. Read-only 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.

ShowType property as it applies to the ConnectorFormat object.

Returns or sets the connector format type. Read/write MsoConnectorType.

MsoConnectorType can be one of these MsoConnectorType constants.
msoConnectorCurve
msoConnectorElbow
msoConnectorStraight
msoConnectorTypeMixed

expression.Type

expression    Required. An expression that returns a ConnectorFormat object.

ShowType property as it applies to the DataLabel and DataLabels objects.

Returns or sets the label type. Read/write Variant.

expression.Type

expression    Required. An expression that returns one of the above objects.

ShowType property as it applies to the Diagram object.

Returns or sets the diagram type. Read-only 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.

ShowType property as it applies to the ListDataFormat object.

Indicates the data type of the list column. Read-only XlListDataType.

This property is used only for lists that are linked to a SharePoint site.

XlListDataType can be one of these XlListDataType constants.
xlListDataTypeNone
xlListDataTypeText
xlListDataTypeMultiLineText
xlListDataTypeMultiLineRichText
xlListDataTypeCounter
xlListDataTypeNumber
xlListDataTypeCurrency
xlListDataTypeDateTime
xlListDataTypeChoice
xlListDataTypeChoiceMulti
xlListDataTypeListLookup
xlListDataTypeCheckbox
xlListDataTypeHyperLink

expression.Type

expression    Required. An expression that returns a ListDataFormat object.

ShowType property as it applies to the HPageBreak and VPageBreak objects.

Returns or sets the page break type. Read/write 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.

ShowType property as it applies to the Parameter object.

Returns or sets the parameter type. Read-only XlParameterType.

XlParameterType can be one of these XlParameterType constants.
xlConstant
xlPrompt
xlRange

expression.Type

expression    Required. An expression that returns a Parameter object.

ShowType property as it applies to the ShadowFormat object.

Returns or sets the shadow format type. Read/write 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.

ShowType property as it applies to the Shape and ShapeRange objects.

Returns or sets the shape type. Read-only 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.

ShowType property as it applies to the SmartTagAction object.

Returns an XlSmartTagControlType that represents the type of Smart Document control displayed in the Document Actions task pane. Read-only 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 Trendline object.

ShowType property as it applies to the Trendline object.

Returns or sets the trendline type. Read/write 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.

ShowType property as it applies to the Window object.

Returns or sets the window type. Read-only 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.

ShowType property as it applies to the Worksheet object.

Returns or sets the worksheet type. Read-only 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

ShowAs 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