One list box at a time, how?

[DentTec]

I have two list boxes and would want to have this happens

If I select an item in list1, none is selected in list2 and vice versa. Right now I can do this with For...Next looping. Is there any other way ? It might take longer as my list gets bigger.

 

[DCrake]

Are each list boxes multi select?

 

[DentTec]

DCrake: no, they are not

 

[DCrake]

Then on the on click of the first listbox

Me.Listbox2 = ""

and vice verca

 

[DentTec]

Beautiful!!!!!
Thank you so much DCrake