Possible to Filter a Listbox on a form?

[skuzapo]

Hi, I have a form with a listbox on it. The listbox is populated from a range on a worksheet.

Is it possible to filter the list box so that it only shows the data based on an entry in a text box or selection in a combo box?

Thanks for any assistanc offered

[Jim Cone]

s,

http://support.microsoft.com/kb/213748/en-us
XL2000: How to Populate One List Box Based on Another List Box

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"skuzapo" wrote in message...
Hi, I have a form with a listbox on it. The listbox is populated from a
range on a worksheet.
Is it possible to filter the list box so that it only shows the data
based on an entry in a text box or selection in a combo box?
Thanks for any assistanc offered
skuzapo

[skuzapo]

Thanks for your input Jim but does this work for one list box being governed by the entry in a text box or a selection in a combo box?

[Jim Cone]

The referenced article uses two list boxes.
One box has a list of States in the USA.
When you select a state the other list box will display cities in that state.
Jim Cone


"skuzapo" wrote in message...
Thanks for your input Jim but does this work for one list box being
governed by the entry in a text box or a selection in a combo box?
skuzapo

[skuzapo]

The problem I'm having with this is that the list contains a few thousand lines. I need to be able to filter the listbox to show just one record - based on the entry in a textbox.

Any further help would be appreciated.
Thanks

[Jim Cone]

s
Maybe...

Private Sub CommandButton1_Click()
ListBox1.RowSource = vbNullString
ListBox1.AddItem TextBox1.Value
End Sub

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"skuzapo" wrote in message
The problem I'm having with this is that the list contains a few
thousand lines. I need to be able to filter the listbox to show just
one record - based on the entry in a textbox.
Any further help would be appreciated.
Thanks
skuzapo