TextureType Property

Microsoft Excel Visual Basic

MsoTextureType can be one of these MsoTextureType constants.
msoTexturePreset
msoTextureTypeMixed
msoTextureUserDefined

expression.TextureType

expression    Required. An expression that returns one of the objects in the Applies To list.

Use the UserTextured method to set the texture type for the fill.

Example

This example sets the fill format for chart two to the same style used for chart one.

Set c1f = Charts(1).ChartArea.Fill
If c1f.Type = msoFillTextured Then
    With Charts(2).ChartArea.Fill
        .Visible = True
        If c1f.TextureType = msoTexturePreset Then
            .PresetTextured c1f.PresetTexture
        Else
            .UserTextured c1f.TextureName
        End If
    End With
End If