message box indicating "no result found" when a cell value is not found in a sheet

Hello everyone,

I am really new to macro. I found the below code from the forum. The code works by looking for the word in the active cell to the rest of the worksheet, if the word match is found in a cell; the cell is filled with yellow color. In addition, I would like to incorporate MsgBox "No result found" if the match is not found in the below code. Currently if the word match is not found in the worksheet, a warning message is shown by excel "Run time error 91: Object variable or with block variable not set". Can anyone please help me with this query?

Please Login or Register  to view this content.

Moderator's note: Please do not attach text files with code. Either attach your entire Excel file, or put the code in your post with CODE tags. I have done this for you. --6StringJazzer

Give this a try:

Please Login or Register  to view this content.

Also I ran your code and did not get an error when the value was not found. What line of code did this error occur on?