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.