FillFormat.PresetTextured Method (Excel)

Sets the specified fill format to a preset texture.

Syntax

expression .PresetTextured(PresetTexture)

expression A variable that represents a FillFormat object.

Parameters

Name

Required/Optional

Data Type

Description

PresetTexture

Required

MsoPresetTexture

The type of texture to apply.

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

See Also

Concepts

FillFormat Object Members

FillFormat Object