Hi all, new to the forum.
Here is my situation. I have a cell that gets different status updates. I would like to write those to a comment and include the date it changed while I keep the last status change and date. Any help with the code would be appreciated.
Last edited by iggy68; 07-28-2013 at 11:58 AM. Reason: Solved
Here is what I have now. I want to keep all the comments every time a change is made.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 1 Then
Comment = Target.Cells & Date
Target.Cells.NoteText Comment
End If
End Sub
Assuming that cell with changing status is A1 you can check, if this code is helpful for you:
Please Login or Register to view this content.
That is what I am looking for. now how do I apply that to the entire column?
Thanks
Got it, silly question
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks