Adding date when editing (adding) information.

Hi

You can only do that with VBA.

Please Login or Register  to view this content.

The code says that when a cell in column C from C2, is modified (entered) the cell in column D in same row is updated with the today date.

Note: I use Sheet1 to put the code.

the above will change the date when the note is edited. However if the note is edited in the future as there is for example a spelling mistake, it will also change the date. this may or may not be what you want

You're literally an Excel God!!

This is amazing! Thank you SO MUCH!

I will play with it, and see if I can adjust it to my needs.

Originally Posted by davsth

the above will change the date when the note is edited. However if the note is edited in the future as there is for example a spelling mistake, it will also change the date. this may or may not be what you want

In this case a little modification

Please Login or Register  to view this content.

The alternate code

Please Login or Register  to view this content.

Hi
You can use the similar code to do multiple actions under the only one Worksheet_Change event.

See the code and the file (D as new and E as update date)

Please Login or Register  to view this content.

Note: The code is executed always any cell in sheet1 is edited.

I might have accomplished what I wanted now.. The only minor issue that might occur, is when you edit a field by accident, and therefore you add a date you didn't wanted.

Although I think this is very close to what I wanted.

Once again, I truly appreciate the help I got. Thank you so much!

Hi


The following code allows you to forget the 'Dato' sheet

The cells of the J: M columns were protected (Format, format cells protection, check box protect). The A: I cells were deprotected.

The 'Faktura' sheet was protected with the password '123'. Feel free to change, , but also change the code so that VBA has the ability to unprotected the sheet.
I also protected the VBA project with the same password (but you can choose a different one) - View Project explorer, under Microsoft Excel Objects, right click and choose VBAProject Properties.
See the code and the file

Please Login or Register  to view this content.

I @Zingo313

Only now I've seen your posts #11 and #12.

Using the 'EnableSelection' sheet property is a good method, but you need to protect ProjectVBA. I do not know the password, but I was able to access the property and change it.

Quem porfia sempre alcança === 'Those who strive always reach out'
Have a nice day.

That makes sense. I will look up a guide to how to lock the codes. You're awesome! Thanks again.

Originally Posted by José Augusto

Hi


The following code allows you to forget the 'Dato' sheet

The cells of the J: M columns were protected (Format, format cells protection, check box protect). The A: I cells were deprotected.

The 'Faktura' sheet was protected with the password '123'. Feel free to change, , but also change the code so that VBA has the ability to unprotected the sheet.
I also protected the VBA project with the same password (but you can choose a different one) - View Project explorer, under Microsoft Excel Objects, right click and choose VBAProject Properties.
See the code and the file

Please Login or Register  to view this content.

This is so good... but how are you able to "erase" the dates again? I can't figure it out. If I delete the field, the date remain.