Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Input Date
Hi,
I was wondering if there is a way to have two columns. One of them will be filled by the user to input data. The other will display the data entry date automatically. Obviously I know of the Today() function. But this is no use to me as everytime I open the sheet the dates will change. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Input Date
Say the data goes in column A and we want the date automatically entered in
column B. Put this worksheet event macro in the worksheet code area: Private Sub Worksheet_Change(ByVal Target As Range) Set r = Range("A:A") If Intersect(Target, r) Is Nothing Then Exit Sub Application.EnableEvents = False Target.Offset(0, 1) = Date Application.EnableEvents = True End Sub -- Gary''s Student - gsnu2007j "Torres" wrote: Hi, I was wondering if there is a way to have two columns. One of them will be filled by the user to input data. The other will display the data entry date automatically. Obviously I know of the Today() function. But this is no use to me as everytime I open the sheet the dates will change. -- Torres |
#3
|
|||
|
|||
Thanks Gary,
It seems to work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation: want input restricted to date value or N/A | Excel Worksheet Functions | |||
Data input based on date list? | Excel Worksheet Functions | |||
Recording Time & Date based on data input | Excel Worksheet Functions | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
Input Date when data is entered into another cell | Excel Worksheet Functions |