FillFormat.PresetTextured Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Sets the specified fill format to a preset texture.

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.

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
Show: