Class DropLines (Excel VBA)

The class DropLines represents the drop lines in a chart group.

Item

To use a DropLines class variable it first needs to be instantiated, for example

Dim dls as DropLines
Set dls = ActiveChart.ChartGroups(1).DropLines

DropLines class variables can be set using the ChartGroup.DropLines procedure.

Border

Returns a Border object that represents the border of the object.

Dim brdBorder As Border
Set brdBorder = ActiveChart.ChartGroups(1).DropLines.Border

Delete

Deletes the object.

ActiveChart.ChartGroups(1).DropLines.Delete

Format

Returns the ChartFormat object.

Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveChart.ChartGroups(1).DropLines.Format

Name

Returns a String value that represents the name of the object.

Dim strName As String
strName = ActiveChart.ChartGroups(1).DropLines.Name

Select

Selects the object.

ActiveChart.ChartGroups(1).DropLines.Select