code filters the list boxes based on what is written in any text box and ignore the empty text box.

[saftawy1]

can you help me in that?
This code filters the list boxes based on what is written in one text box. The code needs to be modified to filter based on what is written in any text box and ignore the empty text box.

Dim i As Integer
Dim ListCount1 As Integer
ListCount1 = ListBox1.ListCount - 1
If TextBox8.Value <> "" Or TextBox9.Value <> "" Or TextBox10.Value <> "" Or TextBox11.Value <> "" Or TextBox12.Value <> "" Or TextBox13.Value <> "" Then
For i = ListCount1 To 0 Step -1
If InStr(1, ListBox1.List(i, 5), TextBox8) = 0 Or InStr(1, ListBox1.List(i, 5), TextBox9) = 0 Or InStr(1, ListBox1.List(i, 5), TextBox10) = 0 Or InStr(1, ListBox1.List(i, 5), TextBox11) = 0 Or InStr(1, ListBox1.List(i, 5), TextBox12) = 0 Or InStr(1, ListBox1.List(i, 5), TextBox13) = 0 Then
ListBox1.RemoveItem (i)

thanks for your interesting

 

[saftawy1]

up

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: filters the list boxes based on what is written in any text box and ignore the empty text
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[saftawy1]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: filters the list boxes based on what is written in any text box and ignore the empty text
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

i am sorry for that