Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoke a macro with the Enter key
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoke a macro with the Enter key
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. "Duncan Help" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoke a macro with the Enter key
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 Duncan Help wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get userform Cancel button to invoke Exit Sub in calling macro? | New Users to Excel | |||
HELP: Setting CNTL-SHIFT-F to invoke Excel2007 macro | Excel Discussion (Misc queries) | |||
add data to combo box in excel then invoke macro | Excel Worksheet Functions | |||
Invoking Excel via Getobject(From Access) to invoke Excel Macro | Excel Programming | |||
invoke macro from outside excel - auto macros | Excel Programming |