InputTitle Property

Applies To

Validation object.

Description

Returns or sets the title of the data-validation input dialog box. Read/write String.

See Also

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

Example

This example turns on data validation for cell E5.

With Range("E5").Validation
    .Add xlValidateWholeNumber, xlValidAlertInformation, xlBetween, "5", "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