(06/10/2024) VB Script in Excel. I have a script that highlights (red color) some specific words and phrases. But the script does make a mistake by highlighting words that are part of phrases too - separately. It is called a ''Prohibited Words' script. And it is run against a text in a Word document. For example, "if and when", "due to the fact", "in the event that", "in order to". are all prohibited phrases that should be avoided in the text. But the script highlights not only the phrases but also all words in the phrases if they exist in the text - like "if", "and", "when" and so on. I need it to be corrected. I know that it is better see that read - but I don't see a way to attach a file here.
Years: Any
Location: Anywhere
Requested on: 2024-06-11
Vbscript, Visual Basic