Re: if statement

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks, that worked.

"Sue Mosher [MVP-Outlook]" <suemvp@xxxxxxxxxxxxxxx> wrote in message
news:eLUtuxukFHA.3380@xxxxxxxxxxxxxxxxxxxxxxx
Well, the more detail you provide the better. We can't read minds. What else
haven't you told us about possible values? Why not just add a second Instr()
to check for "120"?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Joel Allen" <joelallen123@xxxxxxxxxxx> wrote in message
news:%23m57IsukFHA.3960@xxxxxxxxxxxxxxxxxxxxxxx
> Thanks Sue, but sometimes the value is this:
>
> "non-rated,20,120"
>
> "Sue Mosher [MVP-Outlook]" <suemvp@xxxxxxxxxxxxxxx> wrote in message
> news:u%23visstkFHA.3804@xxxxxxxxxxxxxxxxxxxxxxx
> Then use Left() instead of Instr():
>
> If Left(Item.UserProperties("WindowRating"), 2) = "20" Then
>
> "Joel Allen" <joelallen123@xxxxxxxxxxx> wrote in message
> news:%238k4JwskFHA.320@xxxxxxxxxxxxxxxxxxxxxxx
>> Hello,
>>
>> I have this and it doesn't quite work:
>>
>> If InStr(1, Item.UserProperties("WindowRating") ,"20") > 0 Then
>> colFields("min20").CheckBox.Value = True
>> end if
>>
>> I want colFields("min20").CheckBox.Value = True
>> If WindowRating has a 20 in it like this (20 or 20,120), but not if
>> WindowRating only = 120
>>
>> Thanks for your help,
>> Joel
>>
>>
>
>


.

Relevant Pages

  • Re: if statement
    ... We can't read minds. ... Why not just add a second Instr() to check for "120"? ... Sue Mosher, Outlook MVP ...
    (microsoft.public.outlook.program_vba)
  • Re: searching Contacts is totally ineffective
    ... >Sue Mosher, Outlook MVP ... 1: msg in preview window 2: msg open in its own window ...
    (microsoft.public.outlook)
  • Re: searching Contacts is totally ineffective
    ... >>Sue Mosher, Outlook MVP ... > and the other use 'exact phrase' as the method? ... > tendency toward design inconsistency, ...
    (microsoft.public.outlook)
  • Re: IIF Function
    ... >> Sue Mosher, Outlook MVP ... that's not the correct procedure. ... >>>>>I have a checkbox bound to a textfield so that they are connected. ...
    (microsoft.public.outlook.program_forms)
  • Re: Program trying to access e-mail...
    ... >Sue Mosher, Outlook MVP ... >> suspect email that keeps sending and bouncing back. ... >> yest I recently installed Adobe Acrobat 6.0 Pro. ...
    (microsoft.public.outlook)