'Declaration Public Enum DataValidationErrorStyle Inherits System.Enum
public enum DataValidationErrorStyle : System.Enum
Member | Description |
---|---|
Information | Invalid values are allowed. The error dialog shown in Microsoft Excel displays an information icon and ok and cancel buttons. The ok button commits the value to the cell. The cancel button will cancel the edit and revert the cell back to the previous value it contained before the edit operation. |
Stop | Invalid values are not allowed. The error dialog shown in Microsoft Excel displays an error icon and retry and cancel buttons. The retry button will put focus back in the cell and allow the user to try to enter a new value. The cancel button will cancel the edit and revert the cell back to the previous value it contained before the edit operation. |
Warning | Invalid values are allowed. The error dialog shown in Microsoft Excel displays a warning icon, asks the user if they want to continue, and has yes, no and cancel buttons. The yes button commits the value to the cell. The no button will put focus back in the cell and allow the user to try to enter a new value. And the cancel button will cancel the edit and revert the cell back to the previous value it contained before the edit operation. |
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2