Searching in a list box

[Brian Ferris]

Hi guys ...

Here is an interesting one for you

I have a list box on the screen with circa 300 from which
to choose from. All these are unique and the screen is set
up with many 'fields' which change data according to the
option selected in the list box. Basically these are all
linked with a vlookup formula.

This all works fine. Now what i would like is to have an
additional "Search field" were i can input a word and a
search occurs in the list box i,e, in these unique fields
and excel highlights in the list box the one which
contains a similar word. If the word is repeated in
another cell, upon pressing enter the list box highlights
the next one (Similar to the FIND function when pressing
Ctrl F) Additionally a note saying no matches found would
be similar when no matches are found.

Is this possible ???? I can send you the file as an
attachment if I did not make myself clear enough.

Many thanks,
Brian

 

[Dave Peterson]

It sounds like you're describing the improved Edit|Find dialog box in xl2002.

Or Jan Karel Pieterse's FlexFind:
http://www.bmsltd.co.uk/MVP
or
http://www.bmsltd.ie/MVP/

 

[Brian Ferris]

Hi dave,

Thanks for your reply. But what I need is to search in the
actual list box itself. Flexfind does not allow that... Is
there some other way you might know of ?

Thanks in advance for yur support

Brian

 

[Dave Peterson]

I guess just loop through the listbox's list.

But 300 items seems like a pretty high number. Maybe you could do something a
little different.

Depending on what your data is, maybe you could categorize your data, use a
combo box to have say 15-20 categories. Then when the category is chosen, a
smaller number (20-15) of entries will show up in the listbox.

Kind of a dependent list.