Validation is a separate matter from your initial question.

You can get validation with macros and UserForms with the ComboBox in the UserForm rather than in the document.
Create a Simple Userform by Graham Mayor, MVP