Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Skip to end of banner Go to start of banner

Workbook.CreateDataValidation(DataValidation.ValidationType, String)

Skip to end of metadata

Created and last modified by Wiki Administrator on Aug 01, 2011

Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Description

Creates a DataValidation object which can be set on a Range, Area, or Cell.

C#

vb.net

Parameters

allowedType

The data type allowed in the cell.

formula

For 'Custom' allowed type: the formula used to validate the cell's data. For 'List' allowed type: the formula referencing a range in the worksheet.

Returns

A DataValidation object.

Examples

C#

vb.net

No labels