Class HiLoLines (Excel VBA)

The class HiLoLines represents the high-low lines in a chart group.

Item

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

Dim hlls as HiLoLines
Set hlls = ActiveChart.ChartGroups(1).HiLoLines

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

Border

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

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

Delete

Deletes the object.

ActiveChart.ChartGroups(1).HiLoLines.Delete

Format

Returns the ChartFormat object.

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

Name

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

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

Select

Selects the object.

ActiveChart.ChartGroups(1).HiLoLines.Select