Search listbox with combobox and with textbox

Hi,

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