Can this be done thru a user form?

-----Original Message-----
Hi All,

How can I limit the number of items listed in a Data
Validation list by selecting First few letters enterd?

for eg. I have a vlaidation list with more than 500
unique items from which i have to select. what i am
looking for is that if I type a few letters the
validation list should display only items starting with
those letters..

Is it possible thru code or any other way?

Thanks for assistance

Abdul

.

In a userform, the listbox or combox can be set to jump to the closest match
as you type - it doesn't reduce the possible selections, but this should
achieve the desired result. You would need to sort the list.

--
Regards,
Tom Ogilvy


"Abdul" wrote in message
...


Can this be done thru a user form?

-----Original Message-----
Hi All,

How can I limit the number of items listed in a Data
Validation list by selecting First few letters enterd?

for eg. I have a vlaidation list with more than 500
unique items from which i have to select. what i am
looking for is that if I type a few letters the
validation list should display only items starting with
those letters..

Is it possible thru code or any other way?

Thanks for assistance

Abdul

.