Version

FindRule(WorksheetCell) Method

Find the data validation rule applied to the specified cell.
Syntax
'Declaration
 
Public Function FindRule( _
   ByVal cell As WorksheetCell _
) As DataValidationRule
public DataValidationRule FindRule( 
   WorksheetCell cell
)

Parameters

cell
The cell to test.

Return Value

A DataValidationRule-derived instance or null if the cell has no rule applied.
Exceptions
ExceptionDescription
System.ArgumentNullExceptionOccurs when cell is null.
System.ArgumentExceptionOccurs when the cell is from a worksheet other than this collection.
Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also