InputMessage Property

Applies To

Validation object.

Description

Returns or sets the data validation input message. Read/write String.

See Also

Add method (Validation object), ErrorMessage property, ErrorTitle property, IgnoreBlank property, InCellDropdown property.

Example

This example adds data validation to cell E5 and specifies both the input and error messages.

With Range("E5").Validation
    .Add Type:=xlValidateWholeNumber, _
        AlertStyle:= xlValidAlertStop, _
        Operator:=xlBetween, Formula1:="5", Formula2:="10"
    .InputTitle = "Integers"
    .ErrorTitle = "Integers"
    .InputMessage = "Enter an integer from five to ten"
    .ErrorMessage = "You must enter a number from five to ten"
End With