Excel data validation list auto complete?

[JasonPurdueEE]

Hello everybody! I have a workbook that uses data validation to pick from a list. It works great, but I was wondering if there is a way to start typing in the cell and have it auto complete from the list? Any help is greatly appriciated. Please let me know if you need any clarification.

JASON

PS, this is XL2k and Win2k, btw.

______________________________
Sleep is a poor substitute for coffee.

 

[JasonPurdueEE]

As an update:
I have checked to make sure auto complete is turned on in Tools->Options->Edit tab. Is there anywhere else I have to make sure its turned on? I'm beginning to wonder if autocomplete is even support using this method. Again, any help is greatly appreciated.

JASON


______________________________
Sleep is a poor substitute for coffee.

 

[JasonPurdueEE]

bump, I'm still stumped on this one.

______________________________
Sleep is a poor substitute for coffee.

 

[dodgygeezer]

I'm no expert on this stuff but it looks to me like you'd need to create a combo box to do that

 

[xlbo]

don't think autocomplete is possible for data - validation as it only checks whether a completed entry matches the criteria.

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[allan24]

hello there,

I have a problem trying to create a drop down list to select data entries...can anyone help? my list has only 2 names but is repeated for a range of 10. How can i create a drop down list for each cell if i want to enter data..

thanks

 

[jdhilljr]

If you can give a little more detail on what you are trying to do I might be able to help.

Jim

 

[xlbo]

alan24 - please start a new thread - don't piggy back others unless it is the same issue. You are looking in the same area but this is a different issue

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244