program a function key
 

How do I program a function key on my keyboard to enter the current time
into a cell?
In one key press of the function key, the current time should be entered in
"h:mm AM/PM" format.

program a function key
 

bill et.al have done it for u:

[ctrl][shift][;] time (in local format)
[ctrl][;] date (in local format)

else have a look at onkey in vba help

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"John Sheakley" wrote:

How do I program a function key on my keyboard to enter the current
time into a cell?
In one key press of the function key, the current time should be
entered in "h:mm AM/PM" format.