Syntax

expression.ShowError

expression A variable that represents a Validation object.

Example

This example adds data validation to cell A10 on worksheet one. The input value must be from 5 through 10; if the user types invalid data, an error message is displayed but no input message is displayed.

Visual Basic for Applications 
With Worksheets(1).Range("A10").Validation .Add Type:=xlValidateWholeNumber, _ AlertStyle:=xlValidAlertStop, _ Operator:=xlBetween, Formula1:="5", _ Formula2:="10" .ErrorMessage = "value must be between 5 and 10" .ShowInput = False .ShowError = True End With
show Show alert when making incorrect entry? show error Show Error Property ShowError ShowError Property Turn off data validation error alert when user enters invalid data?

See also: