ErrorMessage (属性)

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

示例

python

#本示例向单元格 E5 添加数据有效性验证，并指定输入信息和错误消息
def test():
    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"

python

#本示例显示单元格 A1 的数据有效性检验错误消息
def test():
    print(Range("A1").Validation.ErrorMessage)