Finding text in a string
Hi, Using XL2000
Each cell in Col A contains a random selection of words, such as steel,
brass, aluminium. Comma seperated.
Col B contains user names.
There are upto 500 rows.
The same Words in featured in Col A exist in ComboBox1 in Userform1.
The user selects a word from the list in CB1.
On a click event, I need each row searched and where a text match is found
in each cell in Col A, the contents of Cell B1 are displayed in ListBox1
That is..
At a qualifying row; If A1 contains Steel, Brass, Aluminium AND Steel is
selected from CB1
Listbox1 displays the content of B1
Any VBA ideas appreciated.
Many thanks,
Paul
|