Hi,
I'm trying to restrict the entry of data into cells based on values in a
list.
What I need is similar to Data Validation but I want Excel to complete
the entry after the user has entered just the first character.

For example, In Microsoft Access, when creating a new table in Design
view, first you enter the field name, then tab across to Data Type.
Entering a "c" and then tab automatically enters "Currency" as the data
type. Similar for "d", DateTime; "t", Text etc.

So, in Excel, if I have a list, say, New York, London, Sydney, Tokyo.
Typing "S" and then tab will complete the entry as Sydney.

Sounds simple and I'm sorry if the question has been answered before but
I cant find it any Google searches I've tried.

Bob