Syntax

expression.ShowInput

expression A variable that represents a Validation object.

Example

This example adds data validation to cell A10. 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
Display inputbox and message when user selects cell in the data validation range? Make message appear when entering wrong data? show input Show Input Property ShowInput ShowInput Property

See also: