Automatically clear a cell

B

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?
 
R

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
 
E

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
 
Top