Create filter for Listbox populated data from combobox

  • All,


    I am new to this forum.


    I have a script for data entry with two buttons new entry and change entry.


    For the last one, i am looking to create a automatic filter based on a combobox.


    The data is based in one worksheet, so when you want to change data you can select the transaction in the Listbox. But in there i want the filter that is generated by the Combobox.


    This is the Command for changing data

    In here is mentioned where the listbox data is coming from

  • Welcome to Ozgrid.


    I would suggest before you do anything else that you tidy up your userform. You have controls overlapping each other so they cannot be seen or used.


    Here's an example to filter a ListBox

  • Welcome to Ozgrid.


    I would suggest before you do anything else that you tidy up your userform. You have controls overlapping each other so they cannot be seen or used.


    Here's an example to filter a ListBox

    First off all, thank you your help.


    So sad that i cannot see the example that you mention ^^


    Second of all, what would you suggest to clean or improve in the script.


    We have two kinds of transactions new and change.