My name is Bill and I am a professional bank robber with black hair and a red nose.



My name is Dan and I am bank robber with black hair and a red nose.
My name is Bill and I am a professional bank robber with black hair and a red nose.

Anything after the word professional differs in the sort of comparison my code was making. So not really much good?

Re ActiveX text boxes, as far as I know it is all or nothing with the font colour so you could not colour individual words anyway.

Sorry it's not much help after all.

Maybe you have to get your comparison done outside of Excel?

I've inserted three text boxes via Shapes. I will be dealing with some instances when its just a sentence or two. Im thinking your code would still be very helpful.

Do you think the comparison is better done in Word?

I don't use word at all so have no experience of it but it would appear to have the capability to compare text.

A quick Google came up with this amongst hundreds of others.... http://www.linglom.com/it-support/co...icrosoft-word/

Thanks for all the great info. I really appreciate your time and effort.