Skip to content

Files

Latest commit

author
Docs Allowlist Management
Mar 22, 2024
76d3237 · Mar 22, 2024

History

History
56 lines (38 loc) · 1.56 KB

Excel.FreeformBuilder.md

File metadata and controls

56 lines (38 loc) · 1.56 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
FreeformBuilder object (Excel)
vbaxl10.chm647072
vbaxl10.chm647072
Excel.FreeformBuilder
91c779ac-69bc-3b68-8ecb-1f9cc8e5b20e
03/30/2019
medium

FreeformBuilder object (Excel)

Represents the geometry of a freeform while it's being built.

Remarks

Use the BuildFreeform method of the Shapes object to return a FreeformBuilder object. Use the AddNodes method to add nodes to the freeform. Use the ConvertToShape method to create the shape defined in the FreeformBuilder object and add it to the Shapes collection.

Example

The following example adds a freeform with four segments to myDocument.

Set myDocument = Worksheets(1) 
With myDocument.Shapes.BuildFreeform(msoEditingCorner, 360, 200) 
 .AddNodes msoSegmentCurve, msoEditingCorner, _ 
 380, 230, 400, 250, 450, 300 
 .AddNodes msoSegmentCurve, msoEditingAuto, 480, 200 
 .AddNodes msoSegmentLine, msoEditingAuto, 480, 400 
 .AddNodes msoSegmentLine, msoEditingAuto, 360, 200 
 .ConvertToShape 
End With

Methods

Properties

See also

[!includeSupport and feedback]