Lisbox filters on combobox selection

  • Hi,


    It's the VBA noob again :S


    I have made a userform for data imput with a listbox (10 columns: A:H) showing all the data in sheet1, but i have tried to change this so the listbox only show the data matching the selected name in comboboxName (column A in sheet1). But now my listbox show all in one column. I guess i don't use .addItem rigth?

    Can anyone help me on this issue?

  • Without seeing your workbook it's difficult to help.


    Your code uses a Loop but AutoFilter is the best way to do this, look at this example and try to adapt it to your needs