Excel 2007
I have a worksheet that has several ranges with data validation (for example allowing only integers or list items). I also run the macro below to add the last modified date in the "input message". The problem is that the ".delete" part of the code removes the preexisting data validation.

I cannot find a way to circumvent this problem: I tried simply disabling the ".delete" part of the code, didn't work. I tried writing code that that would store the old data validation and combine it with the inputmessage, but I failed. Is this possible, and if yes - could you point me in the right direction?

Thanks!

'Enters the date when a cell was last modified
Private Sub Worksheet_Change(ByVal Target As Excel.Range)

Dim ccc As Range
Dim text As String

text = ("Cell Last Edited: ") & Format(Date, "dd/mm/yy")
    For Each ccc In Target
         With ccc.validation
            .Delete
            .Add Type:=xlValidateInputOnly
            .InputTitle = "Cell Last Edited:"
            .InputMessage = Format(Date, "dd/mm/yy")
        End With
    Next ccc

End Sub
P.S. should I include the ".delete" code I mention in the first two paragraphs in #code tags on this forum? It seems to me that doing that for a single word would make things a bit messy.