list box value

[frankrss]

Hi,

I have made two list boxes (not user form and not validation) in my excel worksheet.
At this moment i have chosen the name "Wim" in my List B, my question is:

If I choose something in the list A, how can it make the List B to be set up to "All" automatically via VBA?

See attached file.

http://rapidshare.com/files/313291582/list.xls.html

Thanks
Frank

 

[onlyadrafter]

Hello,

create a module in the code and use

Sub set_drop_down()
    Range("k5").Value = 1
End Sub

does this work as expected?

 

[frankrss]

thanks, it works.