Validation.ErrorMessage 属性

返回或设置数据有效性检验错误消息。String 类型，可读写。

语法

表达式.ErrorMessage

表达式 一个代表 Validation 对象的变量。

示例

本示例向单元格 E5 添加数据有效性检验，并指定输入信息和错误消息。

示例代码

示例代码
`let rng = Range("e5").Validation rng.Add(xlValidateWholeNumber, xlValidAlertStop, xlBetween, "5", "10") rng.InputTitle = "Integers" rng.ErrorTitle = "Integers" rng.InputMessage = "Enter an integer from five to ten" rng.ErrorMessage = "You must enter a number from five to ten"`

let rng = Range("e5").Validation
rng.Add(xlValidateWholeNumber, xlValidAlertStop, xlBetween, "5", "10")
rng.InputTitle = "Integers"
rng.ErrorTitle = "Integers"
rng.InputMessage = "Enter an integer from five to ten"
rng.ErrorMessage = "You must enter a number from five to ten"

请参阅

Validation 对象
Validation 对象成员