Hello.
In my userform i have a combobox that refers to a range in one of my sheets.
How could i control the combobox that only values that exist in the range that it refers to can be added to the combobox? Meaning, if i were to enter a value that does not exist in the range then a message box should pop up and the entry should be deleted.

Thanks in advance.