ErrorTitle 属性

       

返回或设置数据有效性错误对话框的标题。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