Invoke a macro with the Enter key

[Guest]

I would like to invoke a little macro that puts a time stamp in the cell on
the right, then moves down one cell. I know how to make the macro, I just
don't know how to attach it to the Enter key.

 

[Guest]

Are you sure about assigning this macro to the Enter key?

It is simple:

application.OnKey "{~}", "Your Macro"
application.OnKey "{ENTER}", "Your Macro"

There are 2 enter keys. Check the help topic OnKey.

 

[Dave Peterson]

As an alternative, you may want to look at how JE McGimpsey does it based on a
cell changing:
http://www.mcgimpsey.com/excel/timestamp.html