Conditional Drop Down Lists

[Reckonin]

Hi,

I am using excel 2007 and have come across an issue.

I have to columns. The first is called "Task" and the 2nd is called "Task Description". Both of these columns are currently drop down lists. Task Description drop down list is changed depending on the selection chosen from the "Task" cell. I am doing this by using data validation and setting the conditional list to be "=INDIRECT(Task)" and then the task has a pre-stored list of possible task descriptions.

The issue I have is that only 2 of the possible 6 choices from the task have a set list for descriptions and the others are meant to be filled in manually. However since I used data validation it requires it to be from the list. Is there any way to have only certain values for "Task" have a list and the others be manually entered.

Thanks in Advance

[ChemistB]

With the Data Validation window open, go to the "Error Alert" tab and uncheck "Show Error Alert after Invalid data is entered" Does that work for you?

[Reckonin]

Thanks,

That will work currently, I am guessing there is no way to lock it such that if there is an associated drop down list to lock out people typing something in.

[ChemistB]

No, you either allow people to type values in or you don't (at least without VBA).

[Reckonin]

What would be the solution using VBA... I am unsure on how to refer to drop down lists within cells using VBA.

[ChemistB]

Here you go (with some help from RomperStomper). Right click on the worksheet tab and "View code" Paste this code in. Modify E1 (cell where original dropdown is) and G1 (cell where secondary drop down is). This also clears G1 each time a new value is selected in E1

Please Login or Register  to view this content.

Does that work for you?

[Reckonin]

Yup thanks alor for your help