Hi all, got a bit of a doozy here, and am really hopeful that one of you already has the DNA for this kind of thing worked out and wouldn't mind sharing...

Unfortunately, my requirements are a little vague, but I think if I can make some progress, I can work on my own to refine the solution as needed. So, here goes.

I'm trying to find a way to compare two large alphanumeric text strings and highlight the differences. The rabbit hole is, of course, in defining "different" and honestly I'm not quite sure yet. But like I said, I'll take whatever I can and work with it.

In a nutshell, I have a userform with 2 text entry fields... similar content will go in each one (the largest same I've seen so far is just shy of 5,000 words), but one of them is considered a "golden copy" - that is, the one that is more correct. The content is cleaned (capitalized, extraneous spaces removed, line breaks normalized) and saved in two strings, Goldenstring and Otherstring. What I'd like to do is find the highlight the differences.

I hope that makes sense - any help is greatly appreciated!