I am trying to filter a multiple column listbox by a combobox and searching the same listbox with a textbox.
My listbox is called listbox1. I want to select combobox1 and filter the listbox1 on column A.
So if I select item "122-22-122" I want only items with "122-22-122" to show in the listbox.
I am also trying to input text into textbox1 and press commandbutton1 and filter the listbox.
So if I enter "555-21-777" it only shows items with that number.
All controls are activex controls and on an userform called userform1.
How can I do this in VBA?
I have crossposted this at https://www.excelforum.com/exc…combobox-and-textbox.html