VBA Excel - how to set PlotArea Format Texture Fill Offset

[jdjehanneman]

Hello,

I would like to modify via VBA code the offset of the texture fill for the PLOTAREA.

In order to be able to adjust the fill inside the plotarea to obtain something like this.

This is the code to activate the texture fill for the chart

Function Functions_AddOffset(Chrt As Chart)
        Chrt.PlotArea.Select
        With Selection.Format.Fill
            .visible = msoTrue
            .UserPicture "C:\tmp\Grey.jpg"
            .TextureTile = msoFalse
        End With
    End Function

The only thing missing is the code to ste thet offset left and right

Hope you guys can help me out.

 

[RoryA]

I can't find any way of accessing that in VBA. If you tile the picture as a texture, then you can set the TextureOffsetX and textureOffsetY in points, but I can't see a way to use percentages.