Repost: How to Limit No of Records in a Validation List
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
.
.
|