Automatically have the date or time inserted into a cell
 

Is there a way to have a cell auto-populated with the current date or time
without having to type it? e.g. click on the cell and the date or time are
entered.

Automatically have the date or time inserted into a cell
 

you can have =now() entered in there. but it updated every time you open the
workbook. I'm sure you'll be seeing some VB programs that'll do it for you...
:-)

"Chris" wrote:

Is there a way to have a cell auto-populated with the current date or time
without having to type it? e.g. click on the cell and the date or time are
entered.

Automatically have the date or time inserted into a cell
 

Indeed there is, using VBA code, but the parameters can vary and the
permanency of the date can be volitile, depending on the conditions........If
you want code, describe a little more clearly exactly when you would like the
date inserted, where, and whether you want it to be frozen in time at that
point........

Vaya con Dios,
Chuck, CABGx3



"Chris" wrote:

Is there a way to have a cell auto-populated with the current date or time
without having to type it? e.g. click on the cell and the date or time are
entered.

Automatically have the date or time inserted into a cell
 

Hi,

Not sure if this will help but here are shortcuts to enter current date and
time without typing them in:

Date - CTRL+;
Time - CTRL+SHIFT+:

HTH
Jean-Guy

"Chris" wrote:

Is there a way to have a cell auto-populated with the current date or time
without having to type it? e.g. click on the cell and the date or time are
entered.

Automatically have the date or time inserted into a cell
 

Need trick ...but how about if you want to round off to 15 minute
increaments going to the nearseast 1/4 hour
pinmaster wrote:
Hi,

Not sure if this will help but here are shortcuts to enter current date and
time without typing them in:

Date - CTRL+;
Time - CTRL+SHIFT+:

HTH
Jean-Guy

"Chris" wrote:

Is there a way to have a cell auto-populated with the current date or time
without having to type it? e.g. click on the cell and the date or time are
entered.

Automatically have the date or time inserted into a cell
 

It is in an Excel worksheet. The ability to simplty click on a specific cell
in columns with the headers 'Date' and 'Time' and thereby enter the date and
time permenantly.

"CLR" wrote:

Indeed there is, using VBA code, but the parameters can vary and the
permanency of the date can be volitile, depending on the conditions........If
you want code, describe a little more clearly exactly when you would like the
date inserted, where, and whether you want it to be frozen in time at that
point........

Vaya con Dios,
Chuck, CABGx3



"Chris" wrote:

Is there a way to have a cell auto-populated with the current date or time
without having to type it? e.g. click on the cell and the date or time are
entered.

Automatically have the date or time inserted into a cell
 

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'Macro inserts date in Column B for change in Column A
'Assumes column B is DATE, and column C is TIME
With ActiveCell
If ActiveCell.Column = 2 Then 'Limits macro action to column B
If Not Selection Is Nothing Then
Application.Selection.Value = Date
Else
End If
Else
End If
If ActiveCell.Column = 3 Then 'Limits macro action to column C
If Not Selection Is Nothing Then
Application.Selection.Value = Time
Else
End If
Else
End If
End With
End Sub

Vaya con Dios,
Chuck, CABGx3



"Chris" wrote:

It is in an Excel worksheet. The ability to simplty click on a specific cell
in columns with the headers 'Date' and 'Time' and thereby enter the date and
time permenantly.

"CLR" wrote:

Indeed there is, using VBA code, but the parameters can vary and the
permanency of the date can be volitile, depending on the conditions........If
you want code, describe a little more clearly exactly when you would like the
date inserted, where, and whether you want it to be frozen in time at that
point........

Vaya con Dios,
Chuck, CABGx3



"Chris" wrote:

Is there a way to have a cell auto-populated with the current date or time
without having to type it? e.g. click on the cell and the date or time are
entered.

Automatically have the date or time inserted into a cell
 

Chris

Without code.............

CTRL + ; enters a static date

CTRL + SHIFT + ; enters a static time

With code............

Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean)
If Target.Column = 1 Then
Target.Value = Date
End If
If Target.Column = 2 Then
Target.Value = Format(Now, "h:mm:ss")
End If
End Sub

Double-click on the cell in column A to enter date.........d-click on a cell in
Column B to enter the time..


Gord Dibben MS Excel MVP

On Mon, 8 Jan 2007 08:31:00 -0800, Chris
wrote:

It is in an Excel worksheet. The ability to simplty click on a specific cell
in columns with the headers 'Date' and 'Time' and thereby enter the date and
time permenantly.

"CLR" wrote:

Indeed there is, using VBA code, but the parameters can vary and the
permanency of the date can be volitile, depending on the conditions........If
you want code, describe a little more clearly exactly when you would like the
date inserted, where, and whether you want it to be frozen in time at that
point........

Vaya con Dios,
Chuck, CABGx3



"Chris" wrote:

Is there a way to have a cell auto-populated with the current date or time
without having to type it? e.g. click on the cell and the date or time are
entered.