Finding specific text in a text string

[janriis]

Hi all

How can I, by using descriptive programming, find a specific text in a text string ?

Example: I want to check if the word "descriptive" exists in the sentence above.

Thanks

[Saket]

use Instr

[janriis]

Could you give me an example of the syntax please.

Thx

[KavitaPriyaCR]

text1="How can I, by using descriptive programming, find a specific text in a text string ?"
'InStr Returns the position where text is located in main string else returns 0

Code:

If (InStr(text1,"descriptive")<>0) Then
   MsgBox "Text Found"
else
   MsgBox "Text Not Found"
End If