Data Validation dependent lists

I came here a couple weeks ago, and got a really great answer to my problem.

I thought.

But I cannot seem to add more dependents using this code. I think it is in the "If / then / else" structure that it is limited to only those three "groups". But I need to be able to add at least one more dependent list to the code.

I really feel like a newbie, since I know that the answer must be right in front of my face...

Thanks in advance for any help.

MAD1c.xlsm

I've not looked at your code, but you can use the Case structure for multiple selections.

Hope this helps.

Pete

I have not used the Case structure before...

I am looking into using it now.

Do you have any links to tutorials or examples? My google-fu is failing me

Tried all I could with this problem, and am getting no where.

Please help; I am trying to extend this set of Data Validation drop down menus to the fourth column.

I can make this work easily using a ton of formulas, but that method makes the workbook both over sized and very slow.

I thought that using VBA would make the job easier, not harder!

Anyone with suggestions, I am open to your ideas.

And I FINALLY cracked this one!!!

(Only problem is that I can't remember which of the dozens of changes I tried did the trick )

I will be posting a fixed copy of the code (for future reference) later.