List Box search

[dark11984]

Hi Guys, I have a list box full of products and I know that you can enter the first letter of the product and it will skip to those products.

I would like to take this a step further and be able to type part of or the full product name in a cell and have the list box skip to that product. Does anyone know a code to do this?

example

list box
beads
beam
bracket
nails20
nails30

If I type "brac" it will skip to bracket or if I type "nails20" it will skip to nails20.

Thanks in advance for your responses.

dark11984

 

[Jaafar Tribak]

You can conviniently use the Worksheet_Change event for this as follows:

Private Sub Worksheet_Change(ByVal Target As Range)
    On Error Resume Next
    
    If Target.Address = Range("A1").Address Then
        
        ListBox1 = Target
    End If
End Sub

Where A1 is the Cell you type the values in and ListBox1 the name of your Listbox- Change these as required.

Regards.

 

[dark11984]

Thanks Jaafar, That works great if you type the full product code.

Is there anyway if you type part of the word you can get the list box to scroll to the products beginning with the letters you typed?

 

[swat2]

Have you looked into the MatchEntry property of the list box? then you don't have to type in a cell you can just type it in the box. The behavior you want is MatchEntry = 1

 

[dark11984]

Thanks Swat, exactly what i wanted. cheers.