Hi,

I have a searchbox that search a single column for word.

my formula is
Private Sub SEARCHBOX_Change()

ActiveSheet.Range("$A$7:$A$2000").AutoFilter Field:=1, Criteria1:="=*" & SEARCHBOX.Text & "*"
End Sub


My problem is it only search for a single word in a cell. how can I make this search for multiple words?

example

I type the word : LAZY JUMP in the searchbox

it should find the cell that contains this: (because this cell contains the word LAZY and JUMP.
The lazy fox jumps over the lazy dog


Is this possible? pls help me.

Thanks