IS JUST PRESENT VALUE IN STRING

User avatar
sal21
PlatinumLounger
Posts: 4576
Joined: 26 Apr 2010, 17:36

IS JUST PRESENT VALUE IN STRING

Post by sal21 »

VALORE="4-8-15"
PATM="4" (but PATM can have also PATM="15", so PATM have a dinamic lenght)

This var are string dimensioned

Now i need if PATM, is just in VAORE, yes in this case

From googling my code is:

If CBool(InStr(1, PATM, VALORE)) Then
stop
end if

dont work

User avatar
HansV
Administrator
Posts: 80088
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: IS JUST PRESENT VALUE IN STRING

Post by HansV »

Does this do what you want?

Code: Select all

    If InStr("-" & PATM & "-", "-" & VALORE & "-") Then
        ...
    End If
Best wishes,
Hans