Classe SeriesGradientStopColorFormat (Excel VBA)

Para usar uma variável de classe SeriesGradientStopColorFormat, ela primeiro precisa ser instanciada por exemplo


Dim sgs as SeriesGradientStopColorFormat
Set sgs = ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor

ObjectThemeColor


ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor.ObjectThemeColor =

RGB


ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor.RGB =

TintAndShade


ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor.TintAndShade =

Transparency


ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor.Transparency =

Type


Dim mctType As Office.MsoColorType
mctType = ActiveChart.FullSeriesCollection(1).SeriesColorMaxGradientStop.StopColor.Type