Show date/time of when cell/column was last edited?

**Bwangster12** · 08-07-2008, 02:32 PM

I have columns in my spreadsheet that will be getting updated periodically with a number. 1 week it might be 24, the next it might be 26.... and they would go in January's price, February's price....

The problem is, if a price is entered into the column, we don't know when it was entered other than the fact that it was entered in that month.

Is there a way to show the date and time of when a number gets entered or edited in a cell? This date/time could perhaps show up in a column right next to it.

**VBA Noob** · 08-07-2008, 02:39 PM

You could try a event macro. Right click sheet name > select view code > paste in the below.

It will add the date and time in Col B (2) if Col A (1) has being changed. Change 1 to your column number

Please Login or Register  to view this content.

VBA Noob

**Bwangster12** · 08-07-2008, 02:55 PM

I see how to change the column that the data is going to be entered, but what if I want to have the date show up in a different column than column B?

If I want to do this on multiple columns... like 6 per sheet... would I paste this and edit it 6 times?

**VBA Noob** · 08-07-2008, 03:02 PM

Try the below

Change this line to your column numbers

Please Login or Register  to view this content.

and change this line for the column offset. Say it's col A and you want the date and time in Col C you would change the offset to 2 and so on

Please Login or Register  to view this content.

Please Login or Register  to view this content.

HTH

Will move to programming also
VBA Noob

**Bwangster12** · 08-07-2008, 03:06 PM

Wow thanks... last ?...

If I instead of wanting the date/time showing up in a separate column wanted the value to appear in a comment box that you hover over in the cell...

is that too complicated?

**VBA Noob** · 08-07-2008, 03:15 PM

Maybe

Please Login or Register  to view this content.

VBA Noob

**Bwangster12** · 08-07-2008, 03:29 PM

Please Login or Register  to view this content.

Sorry does this help? I just want to add the case thing you mentioned before so that I can use it in multiple columns and also add the time show up in the comment box. This seems to work as is.

**Bwangster12** · 08-07-2008, 03:38 PM

Please Login or Register  to view this content.

I was about to figure out how to add the time in. How to I modify this to allow me to use multiple columns? I want to add in that Case thing that you showed me above. This as presently constituted only allows me to use it in 1 column at a time.

**VBA Noob** · 08-07-2008, 03:40 PM

See post 6 for an example

VBA Noob

**Bwangster12** · 08-08-2008, 10:50 AM

Please Login or Register  to view this content.

This code allows me to enter in text/data in a row and then have the date and time show up in a box IN THE SAME ROW a certain number of boxes away.

How do I get the date and time to show up in cell J3 (for example) no matter what cell in Row 3 gets edited? I want just one cell at the far right of the row that keeps getting updated with date/time when a cell in that row is updated. I don't need specific cell date/time stamps... just to know when a row is updated.

**Milfos** · 09-05-2012, 10:59 PM

I'm new to this and I wanted to do the same as the guy above so did the following to get around it:

Please Login or Register  to view this content.

**arlu1201** · 09-06-2012, 03:15 AM

Milfos,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

However,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

**ilo_junior** · 10-24-2013, 03:01 AM

Originally Posted by VBA Noob

You could try a event macro. Right click sheet name > select view code > paste in the below.

It will add the date and time in Col B (2) if Col A (1) has being changed. Change 1 to your column number

Please Login or Register  to view this content.

VBA Noob

I have pasted that code to "this workbook windows code", but it doesn't work. help please.thanks

Show date/time of when cell/column was last edited?

LinkBack

Thread Tools

Rate This Thread

Display

Show date/time of when cell/column was last edited?

Re: Show date/time of when cell/column was last edited?

Re: Show date/time of when cell/column was last edited?

Re: Show date/time of when cell/column was last edited?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions