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

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

Sameer wrote:

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

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

--
Regards,
Tom Ogilvy

"TommyBoy" wrote in message
...
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

Sameer wrote:

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

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



Sameer wrote:

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

--

Dave Peterson

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.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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

Sameer B wrote:

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.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

--

Dave Peterson