Force user to only enter values from dropdown menu in combobox

Hi,
i have this combobox in a userform which has a dropdown menu referring to Vendors in a specific sheet.
How can i control the box so that only the items selected from the dropdown menu can be entered.
I am trying to avoid the match only option under the properties because it doesn't let me customize the message box, and it won't let me clear the box if i decide i want to leave it empty.
here is a code i have which displays the message box and let's me clear any entries and if i enter a name other than what's in the drop box the message box will appear. the only issue (which is a big issue) the code won't let me choose what's in the drop down menu.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by jayesh25

Perhaps is this what you're looking for!!?

Hi jayesh25,
Your code works just fine.
Just curious if code can work right after user goes out of Combo Box as opposed to code working within the combobox.
If not, don't worry too much about it, your code still does the main trick.

Thanks!

Originally Posted by Richard Buttrey

Hi,

Why not use a ListBox rather than a ComboBox?

Hi Richard,
I will look into your suggestion, i will need to change some of the script within the codes so i can test out the listbox.
I will keep you posted.

Thanks.

Kosher, thanks.

Yes you can just change that to this then..

Please Login or Register  to view this content.

Kosherboy, No issues.

This should serve it the other way

Please Login or Register  to view this content.

Super job! Code works very professionally
Thanks a million