I have been able to use a time stamp code to put a date and time in a cell... I then worked out how to use this to list dates and times in the same cell (instead of replacing the cells contents)... using this code:
ActiveCell.Value = ActiveCell.Value & Chr(10) & Format(Date + Time, "dd/mm/yyyy hh:mm")
Now i can use the time stamp to input into a comments box using this code:
ActiveCell.AddComment.Text Format(Date + Time, "dd/mm/yyyy hh:mm")
But i cannot get it to list the dates in the comments box each time i stamp rather than replace the existing comments... Can anyone help?
Bookmarks