View Single Post
 
Old 12-27-2023, 07:35 AM
MiOfficeQuestions MiOfficeQuestions is offline Windows 11 Office 2021
Novice
 
Join Date: Dec 2023
Posts: 1
MiOfficeQuestions is on a distinguished road
Default VBA to find and highlight phrases (NOT just individual words) and also find and replace phrases

Hi,

I'm hoping it's possible to do this, I have been using something that can find and colour in certain words, but I can't figure out how to expand this to phrases, for example.

"Brown Dog" instead of just "Dog" and colour it in (whatever) lets say yellow, this will be a list of words/phrases, but in total most likely no more than 20.

also to find words or phrases and replace, so, where "Fishy" is found, replace with "Smelly", again, with the ability to do this with phrases not just single words.

Thanks in advance for your help
Reply With Quote