Adding "date entered" to worksheet database

[Big Lar]

My UserForm updates my data worksheet.
I’ve added this line of code to include the date of the update.
But the “date entered” column changes all the records to the current day instead of date entered.
I thought about adding code to copy the column and paste values but…is there a better way?

 ws.Cells(iRow, 16).Value = "=Today()"

 

[njimack]

ws.Cells(iRow,16) = Date

 

[James006]

Hello,

You could test

[COLOR=#333333]ws.Cells(iRow, 16).Value = Now[/COLOR]

Hope this helps

 

[Big Lar]

Thanks guys!
I just knew it was going to be a simple fix.