My excel sheet condains names and comments. I made a userform with one textbox and and one search button
cells.Find(What:=strFindWhat, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Select
and i put this in a loop to display a the results in a list in another userform.
I want to search sometimes two words.
Can anyone help me in this?
cells.Find(What:=strFindWhat, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Select
and i put this in a loop to display a the results in a list in another userform.
I want to search sometimes two words.
Can anyone help me in this?