This is possible but I think a strange way of deleting a cell
See application.onkey in the VBA help and run a macro like this
activecell.clearcontents

Signature
Regards Ron de Bruin
http://www.rondebruin.nl
> I'd like to know how/if it is possible to automatically clear a cell when the user presses the Enter key. Any thoughts?
Brandon,
It could certainly be done via a macro. But you need to tell us more.
Certainly you don't want the Enter key to delete any cell you happen to be
in. Which cell? Certain column(s) only? Row(s)? Only a certain sheet?
Only on odd days of the month? Waxing moon only? ???
Earl Kiosterud
www.smokeylake.com
> I'd like to know how/if it is possible to automatically clear a cell when
> the user presses the Enter key. Any thoughts?
BlueDaze - 22 Sep 2005 08:58 GMT
What was in the cell that is being cleared, and how did it get there
--
BlueDaz