dynamic searching a listbox using a textbox in Active X control

  • Hi,


    I have never used Active X controls within a worksheet so not sure if this is feasible or the best approach. I have attached a workbook that has a listbox with approx 3500+ that is populated using "ListFill" within the listbox properties. I was looking to find a way of dynamically using the text box to search the listbox, the textbox would need to be searching the materials which is couln C in the materials workbook. I am ok with the basics of VBA but not sure where to go with this


    Thanks Matt

  • Hi,


    If your objective is to have a Search Function with the AutoComplete feature ... the best alternative would be a ComboBox ...


    Just take a look at following explanation :


    Excel Data Validation Combo box Click

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

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