Add a Picture Style to a Selected picture in VBA

[Chris Macro]

I've been trying to research this one with no luck. Is there any way in VBA that you can use the Office 2007 preset pictures styles on a picture? I specifically want to use the one called "Drop Shadow Rectangle".

 

[Andrew Poulsom]

I don't think the Style is exposed in VBA. It seems you have to apply the relevant properties. Here is some sample Word code that you may find helpful:

Solved: picture style word 2010 - VBA Express Forum

 

[Chris Macro]

Well that's a bummer. Ok so I am trying to make my own drop shadow that is similar to the preset. However the settings I am inputting are not seeming to apply to my targeted picture the way I want them.

I want my shadow to look like:
Transparency: 35%
Size: 100%
Blur: 9pt
Angle: 45
Distance: 9pt

But when I run my code it gives me these settings:
Transparency: 0%
Size: 100%
Blur: 5pt
Angle: 45
Distance: 2.9pt

Code:
<font face=Calibri><SPAN style="color:#007F00">'GRAPH TWO</SPAN><br><br><SPAN style="color:#00007F">Set</SPAN> slide = pwr_app.ActivePresentation.Slides(2)<br><br><SPAN style="color:#007F00">'Copy Graph Range in Excel</SPAN><br>    Sheet5.Range("X25:AJ48").Copy<br>    <br><SPAN style="color:#007F00">'Paste into Powerpoint and resize</SPAN><br>    <SPAN style="color:#00007F">Set</SPAN> ShapeRange = slide.Shapes.PasteSpecial(1)  <SPAN style="color:#007F00">'1 = Bitmap Paste (microsoft constant #)</SPAN><br>        ShapeRange.Left = 328<br>        ShapeRange.Top = 18<br>        ShapeRange.Height = 132<br>        ShapeRange.Width = 217<br>        ShapeRange.Name = "Graph2"<br>        <br>     <SPAN style="color:#007F00">'Format Picture</SPAN><br>     <SPAN style="color:#00007F">With</SPAN> ShapeRange.Shadow<br>        .ForeColor.RGB = RGB(0, 0, 0)<br>        .Blur = 4<br>        .Transparency = 0.6<br>        .OffsetX = 5<br>        .OffsetY = -3<br>        .Visible = <SPAN style="color:#00007F">True</SPAN><br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN></FONT>