comparing text

[chungtinhlak]

can some help me with this. how do i compare wild cards if user input it into a text box. This does not work.


MsgBox (search("textbox1").Value)
If Range("B2").Value Like "*" & search("textbox1").Value & "*" Then
MsgBox ("yes")
End If

[Simon Lloyd]

There are many options for searching wild cards in our own kb here http://www.vbaexpress.com/kb/getarticle.php?kb_id=843 or if you want a tutorial on using/finding them etc look here http://www.cpearson.com/excel/RangeFind.htm