ListBox Column Filter
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: ListBox Column Filter
I have a listbox with a number of columns, one (Status) which contains the text "favorable or unfavorable". I would like to filter on the Status column to show all favorable, unfavorable records or both.
Regards,
John
John
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: ListBox Column Filter
If the RowSource of the combo box is a range on a worksheet, you'd have to extract the filtered records to a separate range, and set that as RowSource.
Alternatively, populate the list box using AddItem. I have attached an example of that approach.
Alternatively, populate the list box using AddItem. I have attached an example of that approach.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
-
- 4StarLounger
- Posts: 582
- Joined: 14 Nov 2012, 16:06
Re: ListBox Column Filter
Example
You do not have the required permissions to view the files attached to this post.