if statement

J

Joel Allen

Hello,

I'm trying to make an if statement that finds a part of the value. For
example:


If Item.UserProperties("test") = "Apple", my if statement could find the
"ppl" in it regardless of case sensitivity.

if Item.UserProperties("test") has "ppl" in it, then......

Hope that make sense, thanks, Joel
 
S

Sue Mosher [MVP]

The function you're looking for is Instr():

myString = Item.UserProperties("test")
If Instr(1, myString, "ppl", vbTextCompare) > 0 Then
MsgBox "myString contains ppl"
End If
 
J

Joel Allen

Thanks. What if I wanted to search for multiple items? I want search for
tbd, N30, etc.... This is not working.

Instr(1, Item.UserProperties("PaymentTerms"), "tbd", "N30", "etc....",
vbTextCompare) > 0

Thanks for your help. I tried to go to VB help, but there's no
documentation about this. Do you have a good reference for syntax questions
like this so I don't have to keep bugging you?
 
S

Sue Mosher [MVP]

You'd need to repeat the Instr() statement for each string you want to
search for. An array might be handy for managing the different search
strings.

You can easily look up the syntax for Instr() by typing it into your code
module, putting the cursor on it, and then pressing F1.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
 
Top