View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Just Me[_4_] Just Me[_4_] is offline
external usenet poster
 
Posts: 2
Default Single key press date input

Thanks all.
SteveC

On Jan 3, 9:26*am, Gord Dibben wrote:
Not possible with one keystroke.

Excel does not know what has been entered in a cell until you signify you are
done with that cell by moving out of that cell using enter key or arrow key or
Tab key.

CTRL + ;(semi-colon) enters a static date.

Gord Dibben * * MS Excel MVP.

On Mon, 3 Jan 2011 09:02:09 -0800 (PST), Just Me
wrote:

I searched the group but may have missed this as it seems like a
common task. I would like to enter the current date into a cell with
just a single key press.the cell,column actually, is formated for date
and pressing D would enter todays date.Any pointers would be greatly
appreciated.
SteveC