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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!