Mutually Exclusive List Boxes

[Kathleen]

Hi,

I have an Excel form containing List boxes. Box one allows a choice of "
0,1,3, or 5 ". Box two allows a choice of " - or D ". My problem is that if
there is a value in Box one, the user can't enter D in box two and vice
versa. Is there a way to do this?

Kathleen

 

[JE McGimpsey]

Hi,

I have an Excel form containing List boxes. Box one allows a choice of "
0,1,3, or 5 ". Box two allows a choice of " - or D ". My problem is that if
there is a value in Box one, the user can't enter D in box two and vice
versa. Is there a way to do this?

I assume you're using a User Form (and so XL04 or a previous version).

You can use the Listbox1 click event to evaluate the user's choice, and
if necessary disable the "D" choice in Listbox2 and vice versa.