contains --VB question

[hateexcel]

I need to look in a string- it is a comment with text in it, and see if it has certain keywords.
something like


If comment contains "keyword" then
do something useful
end if

(please dont shoot me, this is actually for accessVB but it should be the same)

 

[DonkeyOte]

e.g



If InStr(x, "Lloyds") > 1 And InStr(x, "TSB") = 0 Then result = "Lloyds"

 

[hateexcel]

so,
If InStr(comment, "keyword") > 1 Then

that is good, its not highlighted in red!!!
but, if there is only the keword once, shouldn´t i use:
If InStr(comment, "keyword") > 0 Then

Is
If InStr(comment, "keyword") = true Then
also possible?

 

[DonkeyOte]

it was an example...


amend as required...

If = 1 then the string is apparent - then put in your colouring in code...

 

[Legacy 98055]

Highlight InStr and press F1.
The function returns the position of the substring if found within the seqrch string.
Returns 0 if not found.