Filter listbox data based on multiple combobox selection

Hi,
I have a data file where there are data have from A to K column. I am using a userform to view and edit the data and want to restrict edit by manually.
My first query is in comboxbox selection there is Sales and Purchase based on “E” column the same filtered data will mention in Listbox.
In Combobox it will filter the C column data but the header is not coming and the filtered data again will filter by selection of the Combobox3 with based of “I” column Bank name.
My second query is when I will double click a data for edit the data will polulate in text boxes for edit and open edit userform. For Sales data it will create separate form and for Purchase data edit it will open separate form which is not designed yet. Sample file attached. Request for help.

Hi,
The combobox3 filter is working good. But hear I need first filter based on combobox1. And select Sales / Purchase and click on submit button the listbox data will populate only of that data and then after combobox2 and 3 filter should have to work.
Secondly I need data header also need to show in listbox data. And where there is not data of a selection one message will show “No Data of this selection”.
Third if I will double click a selected data then sales userform or purchase userform will open based of the combox1 data selection. Thanks in advance.

Hi Sir,
Thanks. It's working.
Just let know how the header will show everytime in listbox which is not showing and secondly when double clicking on filter data the Sales userform will open when there is record of Sales data and for Purchase data Purchase form will open where i will prepare Edit data and where there is no data after filtered found a message bos will appear for "There is no Data".

Hi Sir,
Thanks for your patience to resolve my query. All the things are working fine. Actually my data header row starts from 7 and I have tried to change a line in code but it gives me error. Request you please help how to change the code accordingly and it will work.

1. In the UserForm module add a red line

Please Login or Register  to view this content.

2. In UserForm_Initialize
change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

3. In CommandButton1_Click
change to red fragment

Please Login or Register  to view this content.

Hi,

I have done the required changes and per your guidelines but in CommandButton1_click error is showing and attached file for your reference.
Sheets("Sheet1").Range("A" & title_row).CurrentRegion.AdvancedFilter 2, .Range("A1:C2"), .Range("A4:K4")

You corrected it wrong.

1. Before in CommandButton1_Click there was

Please Login or Register  to view this content.

Why did you correct it to

Please Login or Register  to view this content.

?

2. Post code #6 requires that there must be at least 1 empty row above the row with titles
Give title in row 8 and correct it to Const title_row = 8
-----------
It is best not to use CurrentRegion but to specify the appropriate Range directly.

Hi Mr. Hungt i apologize for the changes actually i experimented to do this but not done by my side.

Mr. Bakerman,
My issue total resolved and thans a ton to quick revert.

Hi,
Actually i was not aware and now i have done this.