contains --VB question

hateexcel

New Member
Joined
Jul 16, 2002
Messages
31
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)
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
e.g



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

hateexcel

New Member
Joined
Jul 16, 2002
Messages
31
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

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
it was an example...


amend as required...

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

Legacy 98055

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

Forum statistics

Threads
1,144,766
Messages
5,726,173
Members
422,659
Latest member
RGP268

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top