INSTR and not instr
-
- PlatinumLounger
- Posts: 4355
- Joined: 26 Apr 2010, 17:36
INSTR and not instr
I need to ceck if MYvar contain "ok" and not contain "tutto"
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: INSTR and not instr
Code: Select all
If MyVar Like "*ok*" And Not MyVar Like "*tutto*" Then
Code: Select all
If InStr(MyVar, "ok") > 0 And InStr(MyVar, "tutto") = 0 Then
Best wishes,
Hans
Hans