Hi,

I have two cells with drop down lists, now based on a selection made in the first drop down, I require a certain list to appear in the second drop down list. I have created the macros accordingly, they are are running, but if I change my selection, the second drop down still shows the list which ran iin my previous selection, it changes only when I run the macro manually.

I need help to run the macros automatically even the change is made..
Can someone help?

Howdy and welcome to the board.

We would need to see your code. Are your drop down lists Combo boxes, List boxes, or Validation Lists. You can achieve the dependent lists without VBA by using Validation. Check out Dependent Lists (http://www.ozgrid.com/News/excel-dependent-lists.htm).

thanks alot was able to get it done..