Description
Represents an arc graphic object on a chart sheet, dialog sheet, or worksheet. An arc always describes a quarter of a circle or oval.
Accessors
The Arc object is a member of the Arcs collection. Use the Add method to create a new arc and add it to the collection. To access a single member of the collection, use the Arcs method with the index number or name of the arc as an argument.
The following example sets the interior color for arc one.
Worksheets("sheet1").Activate
ActiveSheet.Arcs(1).Interior.Color = RGB(0, 255, 255)
The arc name is shown in the Name Box when the arc is selected. Use the Name property to set and return the arc name.
The following example selects the arc named "Arc 1" on the active sheet and then sets the arc border color.
Worksheets("sheet1").Activate
ActiveSheet.Arcs("arc 1").Select
Selection.Border.Color = RGB(255, 0, 0)
Properties
Application Property, Border Property, BottomRightCell Property, Creator Property, Enabled Property, Height Property, Index Property, Interior Property, Left Property, Locked Property, Name Property, OnAction Property, Parent Property, Placement Property, PrintObject Property, Top Property, TopLeftCell Property, Visible Property, Width Property, ZOrder Property.
Methods
BringToFront Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Select Method, SendToBack Method.