View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Bonallack Daniel Bonallack is offline
external usenet poster
 
Posts: 110
Default Limit entries to combobox

I have a combox box on a form, and let's say it is populated with the months
of the year. I've left it blank, so that as the user types "J a " then
January pops up.

How can I stop the user for typing in a word that isn't in the dropdown
list? Let's say they type "Decmeber" (so they spell it wrong"). Is there a
bit of quick looping code to check whether the entry is valid?

Also, there are 12 comboboxes on my form, so if there is a way to handle all
of them efficiently, even better!

Thanks in advance,

Daniel