Excel.Validation.InputTitle.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Validation.InputTitle property (Excel)	vbaxl10.chm532082	vbaxl10.chm532082	Excel.Validation.InputTitle	77e6bb8b-1fc2-084c-69b7-31b07f8145d3	05/18/2019	medium

Validation.InputTitle property (Excel)

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

Syntax

expression.InputTitle

expression A variable that represents a Validation object.

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

[!includeSupport and feedback]