Beginner - How to use instr function

[Taurus]

I would like to compare the supplier name in my recordset whether
contains the same data I stored in the array.
How should I do the comparison using array i had store and show
whatever related to supplier name in concatenated string. For
exampleoutput) supplier1, supplier2, supplier3 and etc.
How should I do it using instr function?
Thank you.

 

[JE McGimpsey]

I would like to compare the supplier name in my recordset whether
contains the same data I stored in the array.
How should I do the comparison using array i had store and show
whatever related to supplier name in concatenated string. For
exampleoutput) supplier1, supplier2, supplier3 and etc.
How should I do it using instr function?
Thank you.

Perhaps I'm just being dense, but I'm sure I don't understand what
you're trying to do.

Could you describe your situation a bit more?

Are you talking about a VBA array or an XL range?

Where did you store the array?

What is the supplier name supposed to be concatenated with?

 

[Taurus]

I got it figure it out without using array. Thank you anyway.