Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to Filter a Listbox on a form?
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's Profile: http://www.excelforum.com/member.php...o&userid=27430 View this thread: http://www.excelforum.com/showthread...hreadid=520419 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to Filter a Listbox on a form?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to Filter a Listbox on a form?
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's Profile: http://www.excelforum.com/member.php...o&userid=27430 View this thread: http://www.excelforum.com/showthread...hreadid=520419 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to Filter a Listbox on a form?
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to Filter a Listbox on a form?
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 ------------------------------------------------------------------------ skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430 View this thread: http://www.excelforum.com/showthread...hreadid=520419 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to Filter a Listbox on a form?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to filter listbox data in a form? | Excel Discussion (Misc queries) | |||
Filter Rowsource for Listbox | Excel Programming | |||
Listbox and vba auto filter | Excel Programming | |||
ListBox filter | Excel Programming | |||
Filter Listbox in user form | Excel Programming |