I am trying to create a macro that would change a cell to the current date
and time when any of cells L17:L89 values change. If they are deleted,
that's fine, just when they change to something else is the key. The cells
contain yes/no and unsatisfactory/satisfactory answers from a drop down list.
Thx.
--
....It''''''''s The Magnificent!!!

Hi

Place this code in the codesheet for the desired sheet. And change A1 to the
cell reference where you want the date and time to appear.

Private Sub Worksheet_Change(ByVal Target As Range)
Set isect = Application.Intersect(Target, Range("L17:L89"))
If Not isect Is Nothing Then Range("A1") = Now()
End Sub

Regards,
Per

"DJ Magno" skrev i meddelelsen
...
I am trying to create a macro that would change a cell to the current date
and time when any of cells L17:L89 values change. If they are deleted,
that's fine, just when they change to something else is the key. The
cells
contain yes/no and unsatisfactory/satisfactory answers from a drop down
list.
Thx.
--
...It''''''''s The Magnificent!!!