ErrorCheckingOptions.IndicatorColorIndex property (Excel)

Returns or sets the color of the indicator for error checking options. Read/write XlColorIndex.

Syntax

expression.IndicatorColorIndex

expression A variable that represents an ErrorCheckingOptions object.

Remarks

You can specify a particular color for the indicator by entering the corresponding index value. Use the Colors property to return the current color palette.

Example

In the following example, Microsoft Excel checks to see if the indicator color for error checking is set to the default system color, and notifies the user accordingly.

Sub CheckIndexColor() 
 
 If Application.ErrorCheckingOptions.IndicatorColorIndex = xlColorIndexAutomatic Then 
 MsgBox "Your indicator color for error checking is set to the default system color." 
 Else 
 MsgBox "Your indicator color for error checking is not set to the default system color." 
 End If 
 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.