Cell match to display msgbox if found

I have a code that when a cell is double clicked, a value is entered. I want it to first see if there is a match in another range and if there is to display a msgbox. However, what happens is the msgbox comes up every time there is a match, even if it is not in the same row. I am not sure why that is exactly, what do I need to change this?

I want when you double click a cell it checks the range and a msgbox goes up if a match is found, others it input a value into the cell. However, the cell is not the one that needs to be matched, it is 5 cells to the left (Hence why I tried to use CellX).

Please Login or Register  to view this content.

I don't really know how to set one value. I don't want to loop through

Thank you. Now I know how to set specific cells. It worked for me.