Share via

FillFormat.PresetTextured Method

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  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