Search for exact match of string and highlight

Hello All,
I am looking for a VBA code to help me find an exact string in a text and highlight it:
Example: I have following text in a cell and I am looking e.g. for the exact word "seed", and not "seedling". How can I find it and highlight it?

"Seed under water stress: Twenty-four T1 seed from each event (a selfed TO parent) were germinated. Taqman analysis was used to establish zygosity in each seedling. Homozygotes were set aside for seedbulking. Hemizygotes and azygotes were analyzed using the greenhouse water stress protocol. The promoter is also expressed in seed."


Your help is highly appreciated!

Niclal

Hi,

See help of VBA Find method …

You can also activate Macro Recorder and use the Find function from the worksheet menu : you'll get a free code !

Hello Marc,
This will only find a partial match in Excel . I need an exact match.
Thanks
N

Nope ! Can an exact match if you well fill it …

I have used the Find/Replace in Excel and the whole cell is highlighted in red.
So, I would appreciate if you could guide me.
N

Attach a sample file in xlsx format and post your initial code between tags.

Hi,
I have aatached a sample.
I don't have a code
Thank you
book.xlsx

Hi,
I have recorded a macro; however, all words are highlighted red.
N

Please Login or Register  to view this content.

Hi Marc,
Hurray! You did it.
Could I please ask you a favor: Could you explain a bit the different steps so that I can learn. I am still a newbie. Thanks a bunch!
N

Hi Marc,
I am coming regarding one issue: if I search "seed", the word "oilseed" should not be highlighted. What sould be changed in the your code?
Much appreciated!
N

See last edit of previous post …

Thank yoouuuuuuu!
N