返回或设置数据有效性输入对话框的标题。String 类型,可读写。
本示例显示 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