autocomplete (like Access)

[Bob]

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

 

[Gord Dibben]

Bob

If your drop-down list if from Data Validation, you cannot have Autocomplete.

Try a combo-box drop-down list.

Debra Dalgleish has instructions.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

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

Gord Dibben MS Excel MVP