Notifications
Clear all
VBA & Macros
4
Posts
3
Users
0
Reactions
133
Views
Topic starter
Hi I am after some VBA code which might make life easier for myself and a few colleagues!
I have an excel spreadsheet which has text in column A (Description). In the text in this column I wish to search for several keywords which are listed in column E (Keywords). When the macrco finds a keyword in column A it should change the font of the found word to red. A word repeated should be changed twice. Example below
Thanks for your assistance
| Description | Keywords | |||
| Mary had a little lamb | Mary | |||
| When in Rome do as the Romans do | Rain | |||
| Mary Mary quite contrary | rain | |||
| The rain in Spain falls mainly on the plain | ||||
| This little pig when to market | ||||
| Rain rain go away |
Posted : 27/11/2017 10:51 pm
Hi,
Please test the atached file. You can enter new strings in column A and add more keywords in column E.
Clark
Posted : 27/11/2017 11:48 pm
Topic starter
Hi Clark, Thanks for this. It worked really well.
Posted : 28/11/2017 7:34 pm
Hi Clark,
Thank you for your help! It works very well and I am very grateful for that. Can you show me how to do it?
Posted : 07/05/2020 5:26 am
