I have created a data validation list. Now, I want to type the first
character of the word, then the whole word will be displayed like when you
type a word in the combo box, the whole word will be displayed.

E.g. The list is the following:
1. monday
2. tuesday
3. wednesday

When type in "m", it should show "monday". What should I do to make the
whole word shows when typing the first character? please advice. Thanks.

On Jun 16, 1:59 pm, Learning Curve
wrote:
I have created a data validation list. Now, I want to type the first
character of the word, then the whole word will be displayed like when you
type a word in the combo box, the whole word will be displayed.

E.g. The list is the following:
1. monday
2. tuesday
3. wednesday

When type in "m", it should show "monday". What should I do to make the
whole word shows when typing the first character? please advice. Thanks.

You might get away with inserting 3 rows directly above the validation
dropdown, typing "monday", "tuesday" then "wednesday" respectively
into the inserted rows, then hiding those three rows. This will work
if Tools|Options|Edit..."Enable AutoComplete for cell values" is
selected.

Ken Johnson