Is "Contains" a valid operator in formulas"

[Jim Spear]

I am not a VBA programmer, but I am trying to borrow code from within this
discussion group and modify it for my own use and education.

I have not been able to find any references to "contains" for formulas in
custom fields or for VBA.

I want to create a giver-receiver report and I am trying to specify a pred
or succ contains <>\ for my filter or formula.

Of course this may not be elegant, but without knowing more about VBA, I am
limited in possibilities.

Is this a viable approach and is there a "contains" operator to use in
either VBA code or a custom field formula?

Thank you

Jim.

 

[JulieS]

Hi Jim,

Take a look at the InStr function, it can be used both in VBA code as
well as formula. It allows you to test if a certain string (in your
example \) is contained in another string.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project