String containing Another String value

Question

Is there any possibilities to ask such a thing :

If me.cbo.Column(0) = "certain value containing let's say "ABC"" Then

So if there's 123ABC or ABC123 or even 123ABC123, then it will be valid ?

No, it won't since you require equal values. 123ABC does not equal ABC. — mooseman
– mooseman, Commented Nov 20, 2017 at 18:38

braX · Accepted Answer · 2017-11-20 20:14:06Z

4

Instead of = "ABC" use Like "*ABC*"

If me.cbo.Column(0) Like "*ABC*" Then

The *'s act like wildcards.

Another option would be like this:

If Instr(me.cbo.Column(0), "ABC") > 0 Then

answered Nov 20, 2017 at 18:32

braX

11.9k5 gold badges24 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

If me.cbo.Column(0) = "ABC" Then Like this ?