Class SparkPoints (Excel VBA)

The class SparkPoints represents the settings of the markers for points of data on a sparkline.

Item

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

Dim sps as SparkPoints
Set sps = ActiveCell.SparklineGroups(1).Points

SparkPoints class variables can be set using the SparklineGroup.Points procedure.

Firstpoint

Returns a SparkColor object that represents the color and visibility of the marker for the first point of data on a sparkline.

The Firstpoint property corresponds to the setting of the First Point check box in the Show section, and of the First Point item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.

Dim scrFirstpoint As SparkColor
Set scrFirstpoint = ActiveCell.SparklineGroups(1).Points.Firstpoint

Highpoint

Returns a SparkColor object that represents the color and visibility of the marker for the highest point of data on a sparkline.

The Highpoint property corresponds to the setting of the High Point check box in the Show section, and of the High Point item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.

Dim scrHighpoint As SparkColor
Set scrHighpoint = ActiveCell.SparklineGroups(1).Points.Highpoint

Lastpoint

Returns a SparkColor object that represents the color and visibility of the marker for the last point of data on a sparkline.

The Lastpoint property corresponds to the setting of the Last Point check box in the Show section, and of the Last Point item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.

Dim scrLastpoint As SparkColor
Set scrLastpoint = ActiveCell.SparklineGroups(1).Points.Lastpoint

Lowpoint

Returns a SparkColor object that represents the color and visibility of the marker for the lowest point of data on a sparkline.

The Lowpoint property corresponds to the setting of the Low Point check box in the Show section, and of the Low Point item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.

Dim scrLowpoint As SparkColor
Set scrLowpoint = ActiveCell.SparklineGroups(1).Points.Lowpoint

Markers

Returns a SparkColor object that represents the color and visibility of markers for positive points of data on a sparkline.

The Markers property corresponds to the setting of the Markers check box in the Show section, and of the Markers item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.

Dim scrMarkers As SparkColor
Set scrMarkers = ActiveCell.SparklineGroups(1).Points.Markers

Negative

Returns a SparkColor object that represents the color and visibility of markers for negative points of data on a sparkline.

The Negative property corresponds to the setting of the Negative Point check box in the Show section, and of the Negative Points item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.

Dim scrNegative As SparkColor
Set scrNegative = ActiveCell.SparklineGroups(1).Points.Negative