Dynamic Validation lists in Excel

Hi all,

I'm a tester and I'm using keyword driven framework for my tests. I need to make dynamic validation lists in my Excel scripts.

I have four columns Screen Name, Environment, Object and Keyword.

For example if I choose the Screen X, I need a list A of n environment names be added, If I choose Y as Environment a list B has to be added and If I choose Z as Objects name, a list C of keywords should be added.

I need to add all the lists from text files, for each list I has a text file that conatins all the items of this list seperated by a comma.

I created a macro that do this only for the first list means if in the first column I choose X it displays list A.

HTML Code: 

Can any one please, help me to make this Sub general means it does the same thing for the third and the fourth column and what ever the input of Column i-1, it display the correspondant list and not for only one input.

I'm here for any additional detail.

Yes, each list in column 2 or 3 or 4 depends to the input of colunm i-1

I'm thinking about naming the text file as the same name of the input of the column i-1 if it is composed of one word or to take the significant word if it is composed of many words. In my case: I have inputs with one word and inputs with more than one word the significant word is made between""

I have two types of inputs: * One word like Allocation * More than one words like Allocation("name1") or Allocation.x("name1")

So if I have one word my file will be named with this word and if I have "" in my input value my text will be named with the word between these ""

Any Suggestions please ??