View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
strive4peace strive4peace is offline
external usenet poster
 
Posts: 20
Default How do ... display current date on double-click? -- Use Ctrl;

Hi George,

why not just use the shortcut key for current date?

Ctrl ; -- Current Date
Ctrl Shift : -- Current Time
Ctrl ;, then SPACE, then Ctrl Shift : -- current date and time together


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



George C. wrote:
On Fri, 13 May 2005 04:28:18 GMT,
(George) wrote:

Hi, I want to be able to have the current date entered into a given
cell, when I double-click it.

It will always be a cell, in one particular column, reserved for date.
Jim