Record the date on which the record is made
 

Hi,

I would like to input some data and the dates on which I input these
data in the adjacent cells on an Excel spreadsheet. An example is like
this one:

Data Dates on which I input the data
12 30-6-2006
13 30-6-2006
15 01-7-2006
17 02-7-2006

Could you tell me the way of doing this using VBA and the way using the
built-in functions of Excel? Thank you.

David

Record the date on which the record is made
 

Hi David

Built-in functions cannot pust values to remote cells, you need VBA for
this. Rightclick sheet tab, choose View Code, paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cel As Range
For Each Cel In Target
If Cel.Column = 1 Then
Cel.Offset(0, 1).Value = Now 'or Date
End If
Next
End Sub

HTH. Best wishes Harald

"cyberdude" skrev i melding
oups.com...
Hi,

I would like to input some data and the dates on which I input these
data in the adjacent cells on an Excel spreadsheet. An example is like
this one:

Data Dates on which I input the data
12 30-6-2006
13 30-6-2006
15 01-7-2006
17 02-7-2006

Could you tell me the way of doing this using VBA and the way using the
built-in functions of Excel? Thank you.

David