Locked choices in dropdown cell and auto go to...

New thread posted here:

http://www.excelforum.com/excel-gene...ml#post2277621

Thanks to JeanRage for referring me to another thread that answered this. The solution is that the Style property must be set to fmStyleDropdownList.

However, note that the behavior will be slightly modified. The user will not see the letters he types. He will only see whatever name matches the letters he types. This is important because if he tries to type in a name that's not on the list, he won't see his own typing. He'll just see the closest fit, and to try another name he'll have to backspace. So the experience is a little counterintuitive.

The alternative would be to include some VBA code to check the value when the user attempts to leave the box, and if the name isn't in the list, give a warning message and delete his entry so he can start again. I can help with that if that's the way you want to go.