modify macro with multiple criterias from comboboxes help

[moosmahna]

Hy everyone,
In my userform i have 5 comboboxes. If there is a value in the comboboxe, then a macro should filter with these criterias. I have a macro that works with combobox 1:

Please Login or Register  to view this content.

My ideas was, that a macro should look in every combobox and if there is a value in one or more comboboxes, then the value(s) should be the criteria(s). But using if-statements would make the code very long. My comboboxes are:
cmb_Anlagegut Field:=2
cmb_Information Field:=3
cmb_Material Field:=4
cmd_Order Field:=5
cmb_Sold Filed:=6

I searched a lot for a macro that I can use, but I had no luck. So can you help me please?

THANKS a lot
Kind Regards

[AlphaFrog]

This is not tested.

Please Login or Register  to view this content.

[moosmahna]

Hy, thanks a lot for the macro. I will test it.

Kind regards

[moosmahna]

Hy AlphaFrog
your code works perfect. Thanks a lot. Can you help me again please? I have a textbox now and if there is a value in this textbox then it should filter all columns and rows if there can this value be found. I tried this code, but I do not get a result:

Please Login or Register  to view this content.

Thanks again
Kind Regards

[moosmahna]

Hy AlphaFrog
your code works perfect. Thanks a lot. Can you help me again please? I have a textbox now and if there is a value in this textbox then it should filter all columns and rows if there can this value be found. I tried this code, but I do not get a result:

Please Login or Register  to view this content.

Thanks again
Kind Regards

[AlphaFrog]

Please Login or Register  to view this content.

You call another procedure called Clear. That is also a command keyword. It's better practice to name procedures something unique e.g.; ClearMe