Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene LunaMoon Excel Discussion (Misc queries) 0 July 28th 08 11:03 PM
Program juanpablo Excel Discussion (Misc queries) 0 July 2nd 08 02:12 AM
My program SM Excel Worksheet Functions 2 October 22nd 05 04:52 AM
My Program SM Charts and Charting in Excel 1 October 21st 05 09:48 PM
The 'DATEDIF' Function is not listed on my Excel program. UOF Excel Worksheet Functions 7 January 5th 05 09:29 AM


All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"