Running a different Active.Cell Offset.....

Good evening ladies and gentlemen,
I have come across a problem and hope someone can assit me.
Basically I have a macro in place that checks to see a certain value from the active cell is in another workbook which works fine.
What i need now is the following...

Cell A3 is edited to have "Hello" inside.
The user then moves cells
Depending on which way the user moves would determine which offset to use to return to that previous cell and run the find macro.
As long as the cell in column A is not empty then the macro is to run, if it is empty then do nothing.
I am currently getting a compile error.
This is what i currently have:

Please Login or Register  to view this content.

Any help much appreciated
Regards
Ross

Where are you getting the error?
And I would use an "Else If" instead of the else for an event macro like yours.