Filter Listbox

**Sniper** · 12-09-2009, 04:12 AM

Is there a way to filter a listbox from the selection in a combobox?

**royUK** · 12-09-2009, 05:08 AM

See this

FilterForm.zip

**Sniper** · 12-09-2009, 07:08 AM

Thanks Roy took me a while but i figured it out.

**wallybur** · 06-26-2014, 09:26 AM

I need this solution please can someone assist fot i need to populate a listbox based on a selection from a combobox.

**Rick_Stanich** · 06-26-2014, 10:01 AM

Is there a local download of this file? I cant use the provided link at work.

**wallybur** · 06-27-2014, 04:36 AM

Hi all,

I hope someone can help me.

I have a form containing a combobox and a listbox. The combobox is populated with Assignee Names.

My worksheet contains 26 columns, I have Column E header as 'Assignee' and Column J for 'Date_Closed'.

I want the listbox to be populated with all rows containing the selected Name ONLY if Date_Closed column (J) is blank/null.ie.date not filled yet.

For example, if i select "Ann", the listbox will show all rows in the table that have Assignee Ann for and closed date is still blank.

Please see the attached and thanks in advance

**Fotis1991** · 06-27-2014, 05:16 AM

Guys.

Unfortunately your postS do not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.