Hello everyone,
I'm (sorta) new to the forum, I come here anytime I need help with an issue but this is the first time I can't find a solution to my problem.
I'm trying to find a way to filter a multicolumn ListBox with a ComboBox and a TextBox. Basically, the Listbox has different products in it, with brand, supplier and price for one unit. When my UserForm is initialized, the ListBox is populated with a range from another workbook. The ComboBox is to choose which column I want to filter, the TextBox is to enter the text I want to search (obviously ).
I want the ListBox to be updated everytime I add a character to the TextBox (TextBox_change I guess)
I know I need an If ComboBox.value = "Brand" Then... but I don't know how to search the ListBox in this exact column or how to remove the items that don't contain the text searched.
I also need the ListBox to revert to the full list if I clear the TextBox. Probably just need a line with ListBox.List = range with some conditions in the TextBox_Change
Any ideas on how I can do this?
Bookmarks