Date Stamp at a tap

S

s6guy1

I don't know if Excel has this functionality. What I am trying to do is
to have Excel place a time stamp as part of a log. This is to be
transfereable to my palm TREO through "Doc's To Go". Data entry on a
Palm can be tough at times.
I'd just like to tap the cell and get the current time stamp. and not
to have it update or change. This is to be just a log date and time.
There could be upwards of 150 of these on a sheet, all different.
I've tried =now(). This really just gives me a date and time and will
change with my computers clock.
Hope some of you Guru's can help.

Thanks
 
B

Bob Phillips

Ctrl-; does that for you.

Or you could try event code

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target.Value = Format(Date, "dd mmm yyyy")
Target.Offset(0, 1).Select
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Danny@Kendal

s6guy1 said:
I don't know if Excel has this functionality. What I am trying to do is
to have Excel place a time stamp as part of a log. This is to be
transfereable to my palm TREO through "Doc's To Go". Data entry on a
Palm can be tough at times.
I'd just like to tap the cell and get the current time stamp. and not
to have it update or change.
Click to expand...

CTRL ; (enters the date)
followed by
SPACE
followed by
CTRL : (enters the time)

A quick browse through the help files doesn't seem to list anything which
inserts the date AND time in one go. There should be a way to insert the
current date/time into the current cell with a macro and then assign a
keyboard shortcut to it.
 
D

Danny@Kendal

Danny@Kendal said:
CTRL ; (enters the date)
followed by
SPACE
followed by
CTRL : (enters the time)

A quick browse through the help files doesn't seem to list anything which
inserts the date AND time in one go. There should be a way to insert the
current date/time into the current cell with a macro and then assign a
keyboard shortcut to it.
Click to expand...

Ah! Just found it.

Create the following as a macro

Sub insertDateTime()
ActiveCell.Value = Now()
End Sub

Then select it from your list of macros, choose 'options' and assign a
keyboard shortcut.

I've just tried it and it seems to work.
 
Top