Select UserForm ListBox value from matching value

I have cells from a worksheet which contains substrings delimited in ","

For each of these cells, i want to select the values from a corresponding UserForm ListBox that matches each of the substring values.

What is the best way to code this out?

Thanks.

Try this:-
NB:- Substrings taken to be in column "A".

NB:- Userform Has controls:- "ListBox1" and Commanbutton1
NB:- ListBox filled by "Rowsource"

Please Login or Register  to view this content.

Regards Mick