I have a spreadsheet with a validated list. I am trying to find a way to
make excel enter the time/date that a user selects an option from the list.
I need the time/date to be automatically entered into a cell next to the cell
with the list. Is this possible?

It can be done with a macro but nothing inherant in XL will do that for
you... Did you wnat the Code to do this???

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then Target.Offset(0, 1).Value = Now()
End Sub

To add this code right click the sheet tab where you wnat the time stamps
and select view code. Past the above code and change the Target.Column = 1 to
the numb of the column where the user will be making the change...
--
HTH...

Jim Thomlinson


"nkidd" wrote:

I have a spreadsheet with a validated list. I am trying to find a way to
make excel enter the time/date that a user selects an option from the list.
I need the time/date to be automatically entered into a cell next to the cell
with the list. Is this possible?