View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
David McRitchie
 
Posts: n/a
Default insert date and time picker

Hi Vernon,
To insert current date: ctrl+semicolon
To insert current time: Ctrl+Shift+colon
To insert current Date and Time: Ctrl+semicolon space ctrl+shift+colon

To enter automatically in a cell when you fill in another cell, you can use
an event macro;
DateTimeStamp in Column A, on first entry in any other column on row (#datetimestamp)
http://www.mvps.org/dmcritchie/excel...#datetimestamp
Worksheet Events are installed with the worksheet by right-clicking on the sheettab,
choose 'view code', and then paste in your macro.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Vernon Green" <Vernon wrote in message ...
The Date and Time Picker is not available in the Control Box