chungtinhlak
03-26-2009, 07:13 AM
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
MsgBox (search("textbox1").Value)
If Range("B2").Value Like "*" & search("textbox1").Value & "*" Then
MsgBox ("yes")
End If