Automatically clear a cell

[Brandon]

I'd like to know how/if it is possible to automatically clear a cell when
the user presses the Enter key. Any thoughts?

[Ron de Bruin]

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Brandon" <deanfamily@erols.com> wrote in message news:%23ckATmzuFHA.3188@TK2MSFTNGP14.phx.gbl...
> I'd like to know how/if it is possible to automatically clear a cell when the user presses the Enter key. Any thoughts?
>

[Earl Kiosterud]

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

"Brandon" <deanfamily@erols.com> wrote in message
news:%23ckATmzuFHA.3188@TK2MSFTNGP14.phx.gbl...
> 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]

What was in the cell that is being cleared, and how did it get there?