ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   AddNodes msoSegmentCurve (https://www.excelbanter.com/excel-discussion-misc-queries/86563-addnodes-msosegmentcurve.html)

Bubb

AddNodes msoSegmentCurve
 
Can someone explain the arguments BuildFreeForm uses to create a curve
(or point me to a site)? Help doesn't really explain what these
arguments are doing. I am trying to create a rectangle with rounded
corners. Thanks!


Andy Pope

AddNodes msoSegmentCurve
 
Hi,

Do you need to you Freeform?
Macro recorder gave me this code for a rectangle with rounded corners.

ActiveSheet.Shapes.AddShape msoShapeRoundedRectangle, _
227.25, 268.5, 149.25, 63

Cheers
Andy

Bubb wrote:
Can someone explain the arguments BuildFreeForm uses to create a curve
(or point me to a site)? Help doesn't really explain what these
arguments are doing. I am trying to create a rectangle with rounded
corners. Thanks!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Bubb

AddNodes msoSegmentCurve
 
I do need to create the object using Freeform code because I then want
to use mathematics to bend and deform the object. So I need some
guidance on using the Freeform arguments.



All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com