PresetTextured Method

Applies To

ChartFillFormat object, FillFormat object.

Description

Sets the specified fill format to a preset texture.

Syntax

expression.PresetTextured(PresetTexture)

expression An expression that returns a FillFormat object.

PresetTexture Required Long. The preset texture. Can be one of the following MsoPresetTexture values: msoPresetTextureMixed, msoTextureBrownMarble, msoTextureCloth, msoTextureCork, msoTextureGranite, msoTextureGreenMarble, msoTextureMediumWood, msoTextureOak, msoTexturePaper, msoTextureSand, msoTextureWalnut, msoTextureWhiteMarble, or msoTextureWovenMat.

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