Type Property
Type property as it applies to the Axis object.
Returns or sets the Axis type. Read/write XlAxisType.
| XlAxisType can be one of these XlAxisType constants. |
| xlCategory |
| xlSeriesAxis |
| xlValue |
expression.Type
expression Required. An expression that returns an Axis object.
Type 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.
Type 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.
Type 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.
Returns or sets the object type. Read-only Long.
expression.Type
expression Required. An expression that returns one of the above objects.
Type 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.
Type 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.
Type 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.
Type 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.
Type 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.
Type 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.
Type 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.
Type 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.
Type 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.
Type 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.
Type 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.
Type 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
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