Hi Nil,

If your list comes from some other sheet than you can do it in my way.

Say your one list is at Sheet1 and you have named the list as "MyList".
Now at the other sheet where you want to display your list. Make your
list the way you already did. But, at the list box, type the formula

=IF(A1="",MyList,"")

Something like this.

So, when A1 is blank, you can have the list, otherwise not.

Hope that helps.

Thankyou,

Shail


wrote:
Hi,

Can you help me out to find out a solution about the following..

I have 4 columns in my worksheet,each of them is validated with List of
certain range.I have to check the left cell is blank or not,if the
previous cell(row wise) is not blank then the next cell will allow the
list,otherwise thoe cells will not accept any value.For the 3rd
column's cell ,previous 2 cells has to be checked and follows.

How can I implement that?

Thanks

Regards,
Nil