Validation.ErrorTitle Property

Syntax

expression.ErrorTitle

expression A variable that represents a Validation object.

Example

This example adds data validation to 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

Change the text on the title bar of data validation error box? error title Error Title Property ErrorTitle ErrorTitle Property Set the title for error dialog box?

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

See also: