Validation.InputTitle Property

Syntax

expression.InputTitle

expression A variable that represents a Validation object.

Example

This example turns on data validation for cell E5.

Visual Basic for Applications

Visual Basic for Applications
`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`

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

Find out what title will be displayed on data validation input dialog box? input title Input Title Property InputTitle InputTitle Property

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

See also: