InputTitle (属性)

返回或设置数据有效性输入对话框的标题。String 类型，可读写。

示例

/*本示例向单元格 E5 添加数据有效性检验，并指定输入信息和错误消息。*/
function test() {
    let validation = Application.Range("E5").Validation
    validation.Add(xlValidateWholeNumber, xlValidAlertStop, xlBetween, "5", "10")
    validation.InputTitle = "Integers"
    validation.ErrorTitle = "Integers"
    validation.InputMessage = "Enter an integer from five to ten"
    validation.ErrorMessage = "You must enter a number from five to ten"
}

/*本示例显示活动工作表上单元格 E1 的数据有效性检验的输入对话框的标题。*/
function test() {
    let validation = ActiveSheet.Range("E1").Validation
    console.log(validation.InputTitle)
}