Run Macro by Pressing Enter Key

Hi,
I have a macro and I would like it to run when the user presses enter after inputing data into a certain cell. Is there any way to do this?
Thanks

Try something like this.

Please Login or Register  to view this content.

It needs to be pasted into the appropriate sheet tab in the VBA editor (Alt F11) and edited to change the target cell and macro name as necessary. The EnableEvents lines are in there to prevent the macro firing again if your other macro changes the value of any cells on the sheet.