Forum Discussion

Kei_1006's avatar
Kei_1006
Copper Contributor
Jul 29, 2021

Picture Scale of PlotArea.Format.Fill.UserPicture

Hi,

 

I am going to change Picture Scale on Chart via VBA.

If I select ".TextureTile = msoTrue", I can set Scale Option as following.

But If I select ".TextureTile = msoFalse", I cannot find Scale Option Commands.

Is there any way to set these Scale via VBA?

 

With cht.PlotArea.Format.Fill
.UserPicture "file.bmp"
.TextureTile = msoTrue

.TextureHorizontalScale = 2
.TextureVerticalScale = 1
End With

 

With cht.PlotArea.Format.Fill
.UserPicture "file.bmp"
.TextureTile = msoFalse

'How do I set Scale of following ???

End With

 

 

Kei

 

 

No RepliesBe the first to reply

Resources