IgnoreBlank 属性 (Excel)Validation.IgnoreBlank property (Excel)

如果指定区域内的数据有效性检验允许空值,则该值为 TrueTrue if blank values are permitted by the range data validation. 读/写 BooleanRead/write Boolean.



_表达式_一个代表**验证** 对象的变量。expression A variable that represents a Validation object.


IgnoreBlank 属性为 True 时,如果单元格为空白,或者 MinValMaxVal 属性所引用的单元格为空白,仍认为该单元格数据有效。If the IgnoreBlank property is True, cell data is considered valid if the cell is blank, or if a cell referenced by either the MinVal or MaxVal property is blank.


本示例使单元格 E5 的数据有效性检验为允许有空值。This example causes data validation for cell E5 to allow blank values.

Range("e5").Validation.IgnoreBlank = True

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.