Conditional Combo Box

Hi

I have a sheet which contains two combo boxes. Combo box 1 contains organisation type and combo box 2 contains a list of regions.

I want the option from the combo box 1 to determine the options shown in the combo box 2

In particular, if they select a certain org. type I want the combo box 2 to be blanked out, but if they select any of the other org types I want the options in combo box 2 to be shown.

Thanks in advanced if you can help.

Check the attached sample for a solution.

- Clay

Hello..

I am looking for a solution for conditional combo box. The problem statement is excetly what I am looking for.

I could not understand - how "=AvailRegions" works in source of data validation.

I do not know who to write and activate codes.

Thanks in advance.