Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
displaying changes
I am needing to display the date and time that text is entered into a
specific cell, and it not change. - is that possible? = example - if and address is entered in A1 -then in A2 I need the date and time that it was entered, without it changing. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
displaying changes
Try this event code:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.AddressLocal = "$A$1" Then Target.Offset(0, 1).Value = Now() End If End Sub Right-click on the sheet tab of the worksheet where you want this to work. Select "View code" to open the Visual Basic Editor (VBE). In the big blank window, paste the above code. Save the workbook, then close the VBE (File Close) to return to regular Excel. If you are new to macros, this link to Jon Peltier's site may be helpful: http://peltiertech.com/WordPress/200...e-elses-macro/ Hope this helps, Hutch "Kackels" wrote: I am needing to display the date and time that text is entered into a specific cell, and it not change. - is that possible? = example - if and address is entered in A1 -then in A2 I need the date and time that it was entered, without it changing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying a zero | Excel Discussion (Misc queries) | |||
Not displaying a value | Excel Discussion (Misc queries) | |||
HELP: text keeps on displaying ############## | Excel Worksheet Functions | |||
Displaying a different value | Excel Discussion (Misc queries) | |||
Displaying #N/A as a zero | Excel Worksheet Functions |