Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can you date time stamp entries in excel
is it possible that when someone puts an entry on a shared worksheet in excel
it can automatically date and time stamp their entry. |
#2
|
|||
|
|||
Private Sub Worksheet_Change(By Target As Range)
On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then With Target .Offset(0, 1).Value = Format(Now, "dd mmm yyy hh:mm") End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "opinky" wrote in message ... is it possible that when someone puts an entry on a shared worksheet in excel it can automatically date and time stamp their entry. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can excel have a button to input (stamp) the systems date and/or . | Excel Worksheet Functions | |||
Exporting from MYOB to Excel the date cell doesn't display as dat. | Excel Worksheet Functions | |||
Excel file modification date | Excel Discussion (Misc queries) | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |