| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit the input in a cell to a single character | Excel Programming | |||
| I type a date (1/05) in a cell, press enter, it reads ####.Why? | New Users to Excel | |||
| how do I make a multiple columns in a single space? (press enter | Excel Discussion (Misc queries) | |||
| Array input in one single cell | Excel Worksheet Functions | |||
| Logging Data Single Input | Excel Programming | |||
![Just Me[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
