AlertStyle Property

Applies To

Validation object.

Description

Returns the validation alert style. Can be one of the following XlDVAlertStyle constants: xlValidAlertInformation, xlValidAlertStop, or xlValidAlertWarning. Read-only Long.

Remarks

Use the Add method to set the alert style for a range. If the range already has data validation, use the Modify method to change the alert style.

Example

This example displays the alert style for cell E5.

MsgBox Range("e5").Validation.AlertStyle