Page 214 - Microsoft Office Excel 2003 Programming Inside Out

Part 3: The Excel Object Model
Microsoft Office Excel 2003 Programming Inside Out

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
Chapter 8
invalid data.
Formula1 This property contains the first (and possibly the only) value used
in a criterion (for example, between 5 and 10 or less than 10).
Formula2 This property contains the second of two values used in a
criterion (for example, between 5 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.

188