Hi!

I am trying to write a macro that searches a range for a list of words and replaces them if found.

I got that part working great. Here is the code for it:

Please Login or Register  to view this content.
Now I would like to modify this code to function like this:

1. Search the range with the strings in the list
2. Show a userform with all matches. looking like this:

http://snag.gy/U1ed6.jpg

3. Change selected cells

The userform preview needs to show all the text that was in the found cell.

Any idea how to implement somthing like this?