Validation.AlertStyle Property (Excel)
Returns the validation alert style. Read-only XlDVAlertStyle.
Syntax
expression .AlertStyle
expression A variable that represents a Validation object.
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