Gets the formula which specifies the accepted values. Syntax Parameters address The address of the cell or region that serves as the basis for relative references, or null to use the top-left cell of the worksheet.format The workbook format with which to parse address.cellReferenceMode The cell reference mode with...
Gets the formula which specifies the accepted values. Overload List
Indicates if this rule is structurally equivalent to another. Syntax Parameters other The rule to compare against Return Value Returns true if the specified other has the same settings as this rule.
Sets the list of accepted values the cell can accept. Syntax Parameters values The list of accepted values. Exceptions Exception Description System.ArgumentNullException Occurs when values is null and the rule is currently applied to a Worksheet. System.ArgumentException Occurs when the values array is empty. Rema...
Sets the formula which specifies the accepted values. Syntax Parameters valuesFormula The formula which provides the accepted values for the rule.address The address of the cell or region that serves as the basis for relative references, or null to use the top-left cell of the worksheet. Exceptions Exception Descr...
Sets the formula which specifies the accepted values. Syntax Parameters valuesFormula The formula which provides the accepted values for the rule.address The address of the cell or region that serves as the basis for relative references, or null to use the top-left cell of the worksheet.format The workbook format ...
Sets the formula which specifies the accepted values. Overload List
Gets or sets the value which indicates whether a drop down should be displayed in Microsoft Excel with the list of accepted values. Syntax Remarks If this is True, a drop down arrow will be displayed next to the cell when it is selected. When the user clicks the drop down arrow, a drop down will be displayed with ...
Tries to obtain the value of the constraint. Syntax Parameters values When the method returns, will be an array of values or null if the list of values could not be obtained. Return Value True if the list of values could be obtained; False otherwise. Remarks The list of values can only be obtained if it was set wi...
Creates a new ListDataValidationRule instance. Syntax