Data Validation Lists - drop down.

[Sameer]

Hi,
I have a Data Validation List which lists a bunch of text values.
First thing is Excel somehow doesn't autocomplete a cell, inspite of a
bunch of them already existing above it. That is ok. What i would
ideally like to provide to the end user is, that once they are inside
the list if they hit the button 'N' or '1', they should be able to go
to the first entry starting with that letter. The list is in sorted
order. I would be extremely appreciative if someone could suggest me
something.

Thanks,
Sameer

 

[TommyBoy]

i don't have the code off hand, but i would write vbscript with a
keydown event, in the event grab the value of the key pressed and then
write code that searches the entries, thats how i would go about it

 

[Tom Ogilvy]

That sounds good, but data validation doesn't interact with or expose itself
for control from a macro.

 

[Dave Peterson]

Maybe you could replace your Data|validation cells with Comboboxes from the
control toolbox toolbar?

 

[Sameer B]

well, i have to use data-validations, because i have plenty of
these(infact a column full of data-validation lists). using combo boxes
for each of them would increase the filesize tremendously and very
inefficient.

 

[Dave Peterson]

I don't think Data|Validation will do what you want.