Description
Represents a line graphic object on a chart sheet, dialog sheet, or worksheet. An arrow is a line with its ArrowHeadStyle property set to something other than xlNone.
Accessors
The Line object is a member of the Lines collection. The Lines collection contains all the Line objects on a single sheet. Use the Add method to create a new line and add it to the collection. To access a single member of the collection, use the Lines method with the index number or name of the line as an argument.
The following example sets the line color for line one on the worksheet named "Sheet1."
Worksheets("sheet1").Lines(1).Border.Color = RGB(0, 255, 0)
The line name is shown in the Name Box when the line is selected. Use the Name property to set or return the name of the line. The following example adds an open arrowhead to the end of the line named "Line 1."
Worksheets("sheet1").Lines("line 1").ArrowHeadStyle = xlOpen
Properties
Application Property, ArrowHeadLength Property, ArrowHeadStyle Property, ArrowHeadWidth Property, Border Property, BottomRightCell Property, Creator Property, Enabled Property, Height Property, Index 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.