Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

date of modification

  Asked By: Kuhaylah    Date: Oct 27    Category: MS Office    Views: 764
  

I want when ever some Buddy makes changes in column A any cell. i want the date
of modification in column B

Share: 

 

5 Answers Found

 
Answer #1    Answered By: Adalhelm Fischer     Answered On: Oct 27

I believe the Change (worksheet event) is what you're looking for.
Check it out in VBA Help.

 
Answer #2    Answered By: Tyreece Thompson     Answered On: Oct 27

In Sheet1 (or whatever sheet):



Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 1 Then

Target.Worksheet.Cells(Target.Row, 2) = Date ' or Time or Now (for
both)

End If

End Sub

 
Answer #3    Answered By: Drew Lewis     Answered On: Oct 27

A procedure could not be triggered by
a change in the value of cell. However whatu can try is making the workbook
share and one can see the track changes so see when was any entry updated on a
cell

 
Answer #4    Answered By: Adalard Fischer     Answered On: Oct 27

: A procedure could not be triggered by a change in the value of cell.

Isn't that what the change event is for?

Private Sub Worksheet_Change(ByVal Target As Range)

' Do something

End Sub

 
Answer #5    Answered By: Paulette Matthews     Answered On: Oct 27

Try this in the worksheet code

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, ActiveSheet.Range("A:A")) Is Nothing Then Exit Sub
Range("B" & Target.Row).Value = Now()
End Sub

 
Didn't find what you were looking for? Find more on date of modification Or get search suggestion and latest updates.




Tagged: