Search a List box using VBA code

[GenieTR]

How do you go about searching a list box? I know by pressing the first letter, it will go to the first occurrence. What I like to do is near the search, like in a combo box, as you type the word it near down the search for that word in the combo box.

 

[SteveR77]

The best option I could give you would be to use a combo box that is set up to always display the list.

List boxes are designed by default to only do a first character match were a combo box will allow character to character matching for a value.


HTH,


Steve

 

[GenieTR]

Thanks