How can Excel auto-select a certain listbox option based on the value of another cell?

Hi all,

My first post -- please be gentle.

I have a sheet with multiple dropdown lists. In the first list (List A), I have three choices. In the second list (List B), there are only two choices, Yes and No.

If the user selects either of the first two options from List A, I would like List B to offer both the Yes and No options as usual. But if the user selects the third option of List A, I would like List B to auto-populate with "Yes."

Anyone have any advice as to how I can do this?

Thanks,

Matt

This code work:

Please Login or Register  to view this content.