Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Newbie
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!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Newbie
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
[newbie] | Excel Discussion (Misc queries) | |||
Real Newbie newbie question | New Users to Excel | |||
Newbie -& I am not getting this | Excel Programming | |||
Newbie Help. Is this possible? | Excel Discussion (Misc queries) | |||
newbie VBA help please | Excel Programming |