Find/Search for part text from a userfrom textbox

[danbates77]

Hi,

Please can someone help me?

I would like a VBA code that can look at a textbox text from a command button on the same userform and can identify a certain word.

for example:

Textbox2 text = Hello, how are you?

The trigger word is "how"

So because the word "how" is in there a message box appears saying yes.

If the word "how" doesn't appear in the textbox2 then nothing happens.

Any help would be appreciated.

Thanks

Dan

 

[Fluff]

How about

   If InStr(1, Me.TextBox2, "how", vbTextCompare) Then MsgBox "Yes"

 

[danbates77]

Absolutely perfect Fluff,

Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.