Microsoft Office Tutorials and References
In Depth Information
Table 8-4. The Properties and Methods of the Validation Object
Attribute
Description
Properties
AlertStyle
This property can be set to one of three Excel constants:
xlValidAlertInformation (which displays an information box),
xlValidAlertStop (which displays a stop box), xlValidAlertWarning
(which displays a warning box).
ErrorMessage
This property contains the user-defined message that appears in
the alert box after a user enters invalid data.
ErrorTitle
This property contains the user-defined value that appears on
the title bar of the alert box that appears after a user enters
invalid data.
Formula1
This property contains the first (and possibly the only) value used
in a criterion (for example, between and or less than ). 10
Formula2
This property contains the second of two values used in a
criterion (for example, between and ). 10
IgnoreBlank
Setting this Boolean property to True allows a user to leave a
cell blank.
InCellDropdown
This property determines whether the cell contains a down arrow
with a list of values from which a user must pick.
InputMessage
This property contains the message that appears in the input box
into which a user enters cell data.
InputTitle
This property contains the value that appears on the title bar of
the input box into which a user enters cell data.
Operator
This property contains the operator of a criterion, which may be
one of the following Excel constants: xlBetween , xlEqual ,
xlGreater , xlGreaterEqual , xlLess , xlLessEqual , xlNotBetween , and
xlNotEqual .
ShowError
A Boolean property that, when set to True , causes Excel to display
a message indicating the user entered invalid data.
ShowInput
A Boolean property that, when set to True , causes Excel to display
the contents of the InputMessage property whenever the cell is
activated.
Type
A property that determines the type of value you will be validating.
The available data types are xlValidateCustom , xlValidateDate ,
xlValidateDecimal , xlValidateInputOnly , xlValidateList ,
xlValidateTextLength , xlValidateTime , and xlValidateWholeNumber .
Value
A Boolean property set to True if all validation rules are satisfied,
or False if at least one rule is not satisfied.
Search JabSto ::




Custom Search