Solved: Data Validation List - Refresh

[asingh]

Hi,

I have a data validation list - A, which is refreshed off another data validation list - B.

The list values for A are from a dynamic named range generated as per the selection on B. Now the data validation list A, is getting refreshed as I want it to, but not immediately visible, till I do not go and click on list A.

Any way I can resolve this, and make it more user friendly..??

So if I choose 1 on list B I get a list of a,b,c,d on list A. But this is not immediately visible (i.e. the first entry)..till I actually do not go and click on list A)

thanks a lot for the help..

asingh

[Bob Phillips]

Put a worksheet change event on the B list that sets the A list value to blank.

[asingh]

Works..thanks..! Perfect.