InStr is not finding the substring/Is it searching the whole string?

Asked Aug 11 '21 at 18:41

Active Aug 11 '21 at 18:42

Viewed 163 times

InStr code and value. We are looking for "M" in StndMCardIndic. StndMCardIndic is "S(16B,17B)|M(18B)|IO(19B)".

As you can see I am searching StndMCardIndic for the character "M". The value of StndMCardIndic is "S(16B,17B)|M(18B)|IO(19B)". A "M" is clearly present. However, it fails to find it. I suspect this is due to the length of the string. If so, how would I find it?

edited Aug 11 '21 at 18:42

Scott Craner

148,073
10
49
81

asked Aug 11 '21 at 18:41

DanielWhite92

4

Change the `= 1` to `> 0`. – BigBen Aug 11 '21 at 18:42
3

^^^^^^Instr returns the relative location of the match and 0 if not found. By using `=1` you are only testing if the string starts with `M` – Scott Craner Aug 11 '21 at 18:43
@BigBen I see it now. Thanks. Not sure why I thought it was a true(1) or false(0) return. – DanielWhite92 Aug 11 '21 at 18:45
@ScottCraner I see it. Thanks! – DanielWhite92 Aug 11 '21 at 18:46
2

A good start would be the [docs](https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/instr-function), which would immediately refute your assumption. Also, why would you use `= 1` if it returned a `Boolean`? – BigBen Aug 11 '21 at 18:55

InStr is not finding the substring/Is it searching the whole string?

0 Answers0