ValidationAlertenum
The type of warning displayed when cell validation fails.
- Stop
Prevent users from entering invalid data in a cell. A Stop alert message has two options: Retry or Cancel.
- Warning
Warn users that the data they entered is invalid, without preventing them from entering it. When a Warning alert message appears, users can click Yes to accept the invalid entry, No to edit the invalid entry, or Cancel to remove the invalid entry.
- Information
Inform users that the data they entered is invalid, without preventing them from entering it. This type of error alert is the most flexible. When an Information alert message appears, users can click OK to accept the invalid value or Cancel to reject it.