Filter Listview based multiple combobox

[hecgroups]

Hello Again,

I am looking for a help on filtering fields on Listview control.

Let say I am searching Emergency main category as Description (English) in column F and I select dental in combobox5 then it will display only those records which is having Emergency in column F and Dental in column I

Another example. Let say I searching Filling in column F (Description (English) and select dental in combobox5 the it will display only those records which is having filling in column f and Dental in column I.

I hope I have explained my request correctly.

Copy of a sample worksheet is attached for your reference.

[jaslake]

Hi hecgroups

Far as I can tell, it's a bit uncertain, as Sample Data does not jive:

• Combobox2 relates to Column B
• Combobox3 relates to Column C
• Combobox4 relates to Column D
• Combobox5 relates to Column I
• Combobox6 relates to Sheet Names.

Is this correct?

[jaslake]

Yes? No? Maybe?

Hi hecgroups

Far as I can tell, it's a bit uncertain, as Sample Data does not jive:

• Combobox2 relates to Column B
• Combobox3 relates to Column C
• Combobox4 relates to Column D
• Combobox5 relates to Column I
• Combobox6 relates to Sheet Names.

Is this correct?

[hecgroups]

Sorry for the delay. yes you are correct.

1 more thing I want to mention.

Let say I enter a criteria and select main category and hit search button. Later on I want to filter the search by Combobox 5. When I select Dental from Comboox5 automatically I will filter the data no need to hit the search button again.

Other case is I enter a criteria and select main category with other filter option whatever maybe class, Type or region and hit search button it will filter and give me the output.

what I am trying to tell you is the filter option should work before or after search.

[jaslake]

Hi hecgroups

Try the Code in the attached...I THINK it accomplishes this...you'll need to tell me...

the filter option should work before or after search

[hecgroups]

Thanks for your effort to help me out. Please give me some time to take a look and get back to you.

[hecgroups]

Thanks jaslake. the file working good but only few things I want to mentioned.

Let say I want to extend my search it is taking lot of time to check again in entire database. let say I search for Emergency in entire pricelist database. After taking 20 to 25 mins it is displaying the result on listview. Then I again I am looking same service in specific class (Ex. Class C+), then again it is searching entire database and taking the same time 25-30 mins.

what I want here is first search will look into database in second search it should look into viewlist records.

For example I am searching Emergency in entire database and found records 500. Then again without changing existing search I am selecting Class C+ then it should look into that 500 records only instead of entire database.

I hope I have explained my issue correctly.

Waiting for your response. if cannot be cone I will mark this thread as solved.

Again thank you very much for your effort to help me out.

[jaslake]

Hi hecgroups

I believe I had forewarned you of this...

http://www.excelforum.com/excel-prog...-workbook.html

See Post #7

5 million records???...the Code may take DAYS to run...

Far as I know, one cannot Filter a List View Control...one can delete records from the List View Control but that's beyond the scope of this Thread.

I'd suggest you get Professional Help in Commercial Services.

[hecgroups]

OK Thanks for your help. Topic marked as solved and reputation is added.