XLDataValidationValuesMBS.allowBlank as Boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

a boolean value indicating whether the data validation treats empty or blank entries as valid, 'true' means empty entries are OK and do not violate the validation constraints.

(Read only property)

XLDataValidationValuesMBS.colFirst as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

the first column of range.

(Read only property)

XLDataValidationValuesMBS.colLast as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

the last column of range.

(Read only property)

XLDataValidationValuesMBS.error as String

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

message text of error alert.

(Read only property)

XLDataValidationValuesMBS.errorStyle as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

the style of error alert used for this data validation.

(Read only property)

XLDataValidationValuesMBS.errorTitle as String

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

title bar text of error alert.

(Read only property)

XLDataValidationValuesMBS.hideDropDown as Boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

a boolean value indicating whether to display the dropdown combo box for a list type data validation (ValidationTypeList).

(Read only property)

XLDataValidationValuesMBS.index as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

the index of data validation.

(Read only property)

XLDataValidationValuesMBS.op as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

the relational operator of data validation.

See ValidationOp* constants.
(Read only property)

XLDataValidationValuesMBS.prompt as String

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

message text of input prompt.

(Read only property)

XLDataValidationValuesMBS.promptTitle as String

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

title bar text of input prompt.

(Read only property)

XLDataValidationValuesMBS.rowFirst as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

the first row of range.

(Read only property)

XLDataValidationValuesMBS.rowLast as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

the last row of range.

(Read only property)

XLDataValidationValuesMBS.showErrorMessage as Boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

A boolean value indicating whether to display the error alert message when an invalid value has.

(Read only property)

XLDataValidationValuesMBS.showInputMessage as Boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

A boolean value indicating whether to display the input prompt message.

(Read only property)

XLDataValidationValuesMBS.type as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

The type of data validation.

See ValidationType* constants.
(Read only property)

XLDataValidationValuesMBS.value1 as String

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

The first value for relational operator.

Use double quotes if you want to specify a list of values directly (for example "A,B,C") and don't use quotes if you want to specify a reference to area with values (for example A1:A6);
(Read only property)

XLDataValidationValuesMBS.value2 as String

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
property	XL	MBS XL Plugin	26.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	All

the second value for ValidationOpBetween or ValidationOpNotbetween operator.

(Read only property)