Checking for part of a string

[jabmod]

If you have a variable JobTitle having "busines manager"
How do I code VB to check that Variable jobTitle contains the word 'Manager'
Note: This variable always has 'manager' as the last word in the string

Thanks.

 

[kphu]

...like *manager

 

[TonyJollans]

Hi jabmod,

Check out the InStr Function. Or, if it's always at the end you could use the Right Function. See Help for details of both.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[dc20]

Tony,

Your "Before you ask a question" link doesn't seem to work.

Tek-Tips - Page Not Found

 

[TonyJollans]

Thanks dc20. I have corrected it.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[