[SOLVED]Last updated cells

[wizzan1]

Hey

I need a little help with this if its possible to do without some addon or something:

excel.jpg


I've managed to make C1 to show when the whole sheet was updated recently with LastModified() formula.


Function LastModified() as Date

LastModified = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")

End Function



But what I need is C1 to show only when A1 OR A2 was recently updated.

Thanks alot!

[Aardigspook]

You can do this using the Worksheet Change event.
Right-click on the sheet name (the tab at the bottom) and select 'View Code' - this will open the VBEditor.
Copy the code below and paste into the area on the right:

Please Login or Register  to view this content.

This will put the time now into C1 whenever A1 or B1 is changed. I think you mean A1 or B1, from your picture - if you mean A1 or A2, as you typed later, then change Range("A1:B1") to Range("A1:A2").

You will need to save the file as a macro-enabled file (.xlsm).

Hope that helps.

[wizzan1]

You can do this using the Worksheet Change event.
Right-click on the sheet name (the tab at the bottom) and select 'View Code' - this will open the VBEditor.
Copy the code below and paste into the area on the right:

Please Login or Register  to view this content.

This will put the time now into C1 whenever A1 or B1 is changed. I think you mean A1 or B1, from your picture - if you mean A1 or A2, as you typed later, then change Range("A1:B1") to Range("A1:A2").

You will need to save the file as a macro-enabled file (.xlsm).

Hope that helps.

Hey!

Yes I meant A1:B1 you're right. I've now entered the macro you gave me and I've enabled macros in my file. What do I have to type into C1 to show the date and time whenever A1:B1 is updated? The cell is blank right now and shows nothing.

Regards!

[MarvinP]

Hi wizzan,

Here is an attached that will update in column C for any changes in A or B.

VBA Change Date and Time in Col C.xlsm

[wizzan1]

Hi wizzan,

Here is an attached that will update in column C for any changes in A or B.

Attachment 630913

Hi MarvinP

Thanks for the file and I've tried it it works fine! In my case it gives me an error, I might have missed something (im a beginner..)

Attachment 630924


I this case I want S4 to display whenever S2 or S3 is updated. I tried to change the code abit but didn't succeed.

Best Regards

[Aardigspook]

What do I have to type into C1 to show the date and time whenever A1:B1 is updated?

You don't need to type anything into C1. The code will automatically put the time now into C1 whenever A1 or B1 is changed.

Note, make sure that you have the code in the worksheet, not in a module. In the VB Editor, it should be in the code for 'Sheet1 (Sheet1)' or similar (if you've named the sheet, it will appear as 'Sheet1 (Summary)' or something like that).

Edit: The cell format will be your default date and time format, until/unless you change that. You could have it show 'Last Updated: 5 jul 19 12:34:56' (for example) by using a custom number format like this:
"Last updated: "d mmm yy hh:mm:ss
That's the English format, the Swedish will be slightly different, depending on the abbreviations for day month etc.

[wizzan1]

You don't need to type anything into C1. The code will automatically put the time now into C1 whenever A1 or B1 is changed.

Note, make sure that you have the code in the worksheet, not in a module. In the VB Editor, it should be in the code for 'Sheet1 (Sheet1)' or similar (if you've named the sheet, it will appear as 'Sheet1 (Summary)' or something like that).

Edit: The cell format will be your default date and time format, until/unless you change that. You could have it show 'Last Updated: 5 jul 19 12:34:56' (for example) by using a custom number format like this:
"Last updated: "d mmm yy hh:mm:ss
That's the English format, the Swedish will be slightly different, depending on the abbreviations for day month etc.

Thanks alot mate!

[Aardigspook]

You're welcome, glad we could help and thanks for the rep.

If you're satisfied that your original question has been answered, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.