updating code selected items based enter a new or change data

[abdelfattah]

hello
I have this code . it shows data when run userform , but what I want when show the user form .it should select items which changes from A: D or any enter new data with use col O DATE
so if I enter a new data or just change data have already existed then it will add date in COL O and should highlight selected items in listbox
sorry my explanation is poor if anybody interest please inform me .

Private Sub UserForm_Initialize()
   MyRowSource = "A2:d" & Str(ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row)
    MyRowSource = Replace(MyRowSource, " ", "")
    ListBox1.RowSource = MyRowSource
End Sub