Hello,

I use a combo box. Each value from the combo box consists of data from multiple columns. I would like to have the ability to filter / search in these values, because of the large number of values it can contain. I.E. when i type something in the combo box or a certain textbox, it automatically searches for all five cells of value whether this piece of text in it. If so, keep the value. If not, remove it. It would thereby not have to make any difference in which column the text is found. Below is what I have so far. I have no idea what kind of code I should be using for the filtering

Function myrange()
Set myrange = Sheet1.[$a$2:$a$1000]
End Function

Private Sub UserForm_Initialize()
For Each cell In myrange
ComboBox1.AddItem cell & " " & cell.Offset(0, 1) & " " & cell.Offset(0, 2) & " " & cell.Offset(0, 3) & " " & cell.Offset(0, 4) 
Next
End Sub