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?
Bookmarks