pre-fill cell by typing first few letters of a list

JohanF

pre-fill cell by typing first few letters of a list

Excel249
I have created a list and have set the cell validation to pick from the list.

I want to be able to just type in the first letter and have the cell pre-fill

with the first item in the list matching the typed letter and keep pulling if

I hit the same letter again. (i.e.-My list contains Cat, Corn, and Cupid.

When I am on a cell with the validation set I type a C and it automatically

fills in Cat, if I hit C again it goes to Corn, again and it goes to Cupid.

It would then wrap around to Cat again if I continued to hit C)

-

HelpFrom

Registered User

Sat Mar 24 00:10:00 CDT 2007

Re:pre-fill cell by typing first few letters of a list

Not exactly what you've asked for, but very close:

http://www.contextures.com/xlDataVal10.html

Instead of jumping from Cat to Corn to Cupid, it will auto-fill based on

what you type:

Ca - will come up with Cat

Co - would go to Corn

Cu - gets you to Cupid.

Debra has some good routines for doing this type of thing, and others

'tricks' with lists.

"Trying to learn!" wrote:

Quote

I have created a list and have set the cell validation to pick from the list.

I want to be able to just type in the first letter and have the cell pre-fill

with the first item in the list matching the typed letter and keep pulling if

I hit the same letter again. (i.e.-My list contains Cat, Corn, and Cupid.

When I am on a cell with the validation set I type a C and it automatically

fills in Cat, if I hit C again it goes to Corn, again and it goes to Cupid.

It would then wrap around to Cat again if I continued to hit C)

-