Returns the validation alert style. Read-only XlDVAlertStyle .
expression . AlertStyle
expression A variable that represents a Validation object.
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.
This example displays the alert style for cell E5.
MsgBox Range("e5").Validation.AlertStyle