ErrorMessage (属性)

返回或设置数据有效性检验错误消息。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"
}

/*本示例显示单元格 A1 的数据有效性检验错误消息。*/
function test() {
    console.log(Range("A1").Validation.ErrorMessage)
}