Skip to content

Latest commit

 

History

History
53 lines (36 loc) · 1.19 KB

Excel.FillFormat.PresetTextured.md

File metadata and controls

53 lines (36 loc) · 1.19 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
FillFormat.PresetTextured method (Excel)
vbaxl10.chm115006
vbaxl10.chm115006
Excel.FillFormat.PresetTextured
44661e53-9aee-7abd-6a6e-b6cb0a97ee2d
04/26/2019
medium

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

[!includeSupport and feedback]