Thread: [Solved] Comparing text and highlighting differences
View Single Post
 
Old 03-17-2015, 05:10 AM
ksigcajun ksigcajun is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: May 2014
Posts: 76
ksigcajun is on a distinguished road
Default
Quote:
Originally Posted by Snakehips View Post
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?
Reply With Quote