Combo Box - Enabled and Disabled based on another Combo Box Entry

[excelrequired]

Please find attached the spreadsheet. Do not use Scoring spreadsheet. Please use Marks Spreadsheet.

I have a 200 row spreadsheet where C2 to C200, all rows have combo boxes. The possible selections within the combo box are "Yes" or "No".

I want a combo box to be enabled in D2 to D200, only if the corresponding C row value is a "yes". If the value is no, the combo box in D column should be disabled and not available for selection.

For Example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]37[/TD]
[TD]Yes[/TD]
[TD]Combo box enabled[/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD]No[/TD]
[TD]Combo Box disabled[/TD]
[/TR]
</tbody>[/TABLE]

Please help me[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Damon Ostrander]

Hi excelrequired,

I didn't find your workbook attached. However, your explanation is sufficient for me to provide code to do what you want. But first I want to make sure that when you refer to "combo box" you have actually inserted combobox objects into all the cells in c2:d200. I suspect you actually are using cell validation lists, which provide in-cell dropdown lists--but these are not comboboxes. If you are using combobox objects I need to know whether they are Forms combobox objects, or ActiveX combobox objects, and how you have named them so that I have a way to determine for each cell the name of the combobox that is in it.

If you are using validation, just let me know.

Damon