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

.

It really doesn't require code. You just use the MatchEntry property:
Here are the choices (from help)

fmMatchEntryFirstLetter
Value: 0
Basic matching. The control searches for the next entry that starts with
the character entered. Repeatedly typing the same letter cycles through all
entries beginning with that letter.


FmMatchEntryComplete
Value: 1
Extended matching. As each character is typed, the control searches for an
entry matching all characters entered (default).


FmMatchEntryNone
Value: 2
No matching.

You need to read the vba help on this to get further information. Look at
some of the other properties of the listbox or combobox as well.

--
Regards,
Tom Ogilvy




"Abdul" wrote in message
...
Hi Tom,

Could you plsgive a code eg. to use in a user form?

TIA
Abdul


-----Original Message-----
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

.



.