substring check

[Net Doe]

In VBA, how can I check if a substring exists in a cell? Say
cells have
ABC123
D123EF
GHI456

How can I test if a cell has "123" in it, in this case, the top 2 cells
will pass the test.

 

[Ron Rosenfeld]

In VBA, how can I check if a substring exists in a cell? Say
cells have
ABC123
D123EF
GHI456

How can I test if a cell has "123" in it, in this case, the top 2 cells
will pass the test.

INSTR function
--ron

 

[Net Doe]

INSTR function

--ron

Thanks!