how to change revision cloud shape VBA code excel 2010

bugserm

New Member
Joined
Mar 20, 2013
Messages
1
Hi,

anyone know how to change the revision cloud from
<v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600">
cloud1m.png

to

cloud2c.png

here is the original code:

Sub Arc(StartX, StartY, EndX, EndY, angle)
Dim ArcHeight As Single
Dim ArcWidth As Single
Dim AspectRatio As Single 'used to adjust the ration of arc height to width

On Error GoTo ErrorHandler
AspectRatio = 0.5 'An Aspect Ratio of 1 = a semi-circle
If StartX = EndX Then 'vertical edge
ArcHeight = Abs(StartY - EndY) / 2
ArcWidth = AspectRatio * ArcHeight
End If

If StartY = EndY Then 'horizontal edge
ArcWidth = Abs(StartX - EndX) / 2
ArcHeight = AspectRatio * ArcWidth
End If

' Draw an arc on the page
Activesheet.Shapes.AddShape(msoShapeArc, StartX, StartY, ArcWidth, ArcHeight).Select

If EndY > StartY Then 'left side
Selection.ShapeRange.Adjustments.Item(1) = -270
Selection.ShapeRange.Adjustments.Item(2) = -90
End If

If EndX > StartX Then 'bottom
Selection.ShapeRange.IncrementLeft ArcWidth
Selection.ShapeRange.IncrementTop -ArcHeight
Selection.ShapeRange.Adjustments.Item(1) = 0
Selection.ShapeRange.Adjustments.Item(2) = -180
End If

If StartY > EndY Then 'right side
Selection.ShapeRange.IncrementTop (-2 * ArcHeight)
Selection.ShapeRange.Adjustments.Item(2) = 90
End If

If StartX > EndX Then 'top
Selection.ShapeRange.IncrementLeft -ArcWidth
Selection.ShapeRange.IncrementTop -ArcHeight
Selection.ShapeRange.Adjustments.Item(1) = 180
End If

Exit Sub

</SPAN><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></v:path><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="WIDTH: 77.25pt; HEIGHT: 16.5pt" id=_x0000_i1025 alt="" type="#_x0000_t75"><v:imagedata o:href="cid:image002.png@01CE2583.9063B4C0" src="file:///C:\DOCUME~1\HANIF~1.KAM\LOCALS~1\Temp\msohtmlclip1\01\clip_image001.png"></v:imagedata></v:shape></SPAN>
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Forum statistics

Threads
1,215,324
Messages
6,124,250
Members
449,149
Latest member
mwdbActuary

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top