DataValidation

[Craig Bart]

How do i select the first row on Data Validation list box? I would like UnChecked to be selected by default in the following code. Thanks.

IDataValidation validation = oSheet.Range["A1 "].DataValidation;

validation.ListOfValues = new string[] { "UnChecked, Checked" };

[Administrator]

you can use oSheet.Range["A1 "].Text = "UnChecked"

[Melba Winshia]

Hi CB,

You can use the following code snippets to select "UnChecked" by default.

[C#]

//Data validation to list the values in the first cell
IDataValidation validation = sheet.Range["A1"].DataValidation;
sheet.Range["A1"].Text = "UnChecked";
validation.ListOfValues = new string[] { "UnChecked, Checked" };

Here is the sample for your reference:

PickLists.zip

Kindly take a look at the sample above and let me know if you have any other questions.

Regards,
Melba

[Craig Bart]

So simply. LOL! Thanks for your help.

[Melba Winshia]

Hi CB,

Thanks for the update!

Thanks,
Melba