find a word in entirebook and highlight it.

Hi Friends,

I need a macro to find a word in entire workbook and need to highlight it. Please help me with the code.



Thanks
Rams

This is my first contribution on VBA code so please be kind if it's wrong.
If you want to input the phrase that is to be searched use this:

Please Login or Register  to view this content.

Hi lopiner and rwgrietveld


Thank you very much for replying my post.

I used lopiner's code it is working even rwgrietveld's code also working.

Thanks & Regards
Ram

Hi lopiner and rwgrietveld,

It is highlighting the entire cell. Can't we highlight the one word in cell which has more than one word.

ex: Cell A1 contains a word like "Chandra Babu Naidu". I want to find a word "babu" and highlight it. Please provide the code if it possible to hightlight in this manner.


Thanks & Regards
Ramesh

Hi rwgrietveld,


It is working fine. Thank you very much for replying my post.


Thanks & Regards
Ramesh

Hi rwgrietveld,

The code sent by you working properly. I need little enhancement on this code. When I find a word all the words with that name turned into red color when I find for second word all the previously founded words color(red) need to turn into black.


Ex: First I find "Ramesh Katta" in the sheet our code finds it and highlight in red color

When I find for second time for other word previously highlighted word ("Ramesh Katta") needs to be turn into black.

I am very sorry for coming every time with new issue.

Please kindly help me with enhancement of the code.


Thanks & Regards
Ramesh

hi rwgrietveld, im sorry if interfere with your discussion, just tell me if i violate again another rule in the forum... i tested ur code and it works... but i want a little revision of that. i want to search a word in sheet2 that much the word in sheet1... is it possible if the excel would jump to sheet2 to from sheet1 with the word i want to search is highlighted....

Hi rwgrietveld,

I need little enhancement for this code.

When I search for second word then the previously founded word needs to turn into black.

ex: We found ABC first time (It found and turned into red color). When I try for second the first founded word "ABC" should turn into black.

I appreciate you for all your help.

Please kindly help me with enhancement of the code.


Thanks & Regards
Ramesh

Hi,

I asked enhancement for this code. The following code performing the task that finding a word in entirebook and highlighting it. What I want now is when find any word second time previously founded words turn into normal color.

Please Login or Register  to view this content.

Please kindly modify the code to turn off the color of font for previously founded words.

Thanks & Regards
Ramesh

Hi rwgrietveld,
I found your code while searching for a routine to do exactly what you generated, it works great. I added a message box to the beginning of the routine so the user can define the variable FindWord each time they run the macro. By any chance would it be too difficult to add two features:

1) have it not be case sensitive? I've noticed it always finds the correct cell regardless of the case matching, but if the cell contains all caps and I enter lower case it doesn't always highlight the correct sub string in the cell.

2) can the routine easily highlight all occurrences of the FindWord in a single cell? In some case the same word will appear more than once in the same cell.

Thanks so much for a great routine!