I have a combobox with a range in "X6:X829".
I also have anoter list in "V6:V389" with some names from "X6:X829".

What I want is:

If the name of the combobox.text belongs to range "V6:V389" then show a message in B7 ("Attention" in red).

I thought it was easy to me (noob), but it turned out to be a pain in the...

Can anyone help me with that?