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…combobox-and-textbox.html

Participate now!

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