Add textbox value if new and provide date if it is overwriting value of old

[Templemind]

I have a userform that inputs a textbox value into a sheet and the cell next to it creates the date when the value was added (this is done manually with formula). The textbox value is a name and I want two columns beside it to state when the original date the name was inputted and another column to insert a date if the the name was entered again.

Here is my current code for adding the name:

Please Login or Register  to view this content.

Here is the formula I use for the date when first added:

Please Login or Register  to view this content.

I am showing my inexperience because I just copied the formula in over 11000 cells. I haven't put it into code yet. Is this possible to have both dates, or can I only have one or the other? I couldn't find the code or formula to add because the name doesn't overwrite the old one.

This sheet is not really to be viewed by anyone, but the form I have on another sheet keeps track of it, so it can be messy.

[Bernie Deitrick]

Convert the formulas in column B to values so that they no longer are calculated.

Then use code like this, and choose one of the two lines after
If Not IsError(Res) Then
to uncomment, depending on what you want to actually do.

Please Login or Register  to view this content.

[Templemind]

That works great thank you. I had to made a change so that it doesn't add a new column every time the name was entered, which I never really mentioned. I just wanted the two columns, which the third changes every time it is entered rather than a new column being entered. Thank you.

[Templemind]

Sorry to bother you again, but it doesn't seem to work. Whenever I input the name it puts the date and when I put the same name in it adds a date in the next cell, which is good, but the first date is then changed as well, which is not what was intended. I cannot find what is wrong, can you?

[Bernie Deitrick]

The code that I posted would not do that. Did you convert all your formulas in column B to values? What version of the code did you end up running?

[Templemind]

I converted them to the Date: m/d/yyyy. Here is the code I used

Please Login or Register  to view this content.

The only thing I changed the Columns.Count to 2.

[Bernie Deitrick]

Only write one date if the value exists - maybe this will be clearer, instead of using offset

Please Login or Register  to view this content.

[Templemind]

That makes more sense, thank you.