+ Reply to Thread
Results 1 to 13 of 13

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

  1. #1
    Registered User
    Join Date
    07-30-2008
    Location
    NY
    Posts
    19

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

    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.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    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
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    07-30-2008
    Location
    NY
    Posts
    19
    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?

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    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

  5. #5
    Registered User
    Join Date
    07-30-2008
    Location
    NY
    Posts
    19
    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?

  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Maybe

    Please Login or Register  to view this content.
    VBA Noob

  7. #7
    Registered User
    Join Date
    07-30-2008
    Location
    NY
    Posts
    19
    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.

  8. #8
    Registered User
    Join Date
    07-30-2008
    Location
    NY
    Posts
    19
    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.

  9. #9
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    See post 6 for an example

    VBA Noob

  10. #10
    Registered User
    Join Date
    07-30-2008
    Location
    NY
    Posts
    19
    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.
    Last edited by Bwangster12; 08-08-2008 at 11:07 AM.

  11. #11
    Registered User
    Join Date
    09-05-2012
    Location
    NZ
    MS-Off Ver
    Excel 2010
    Posts
    1

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

    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.
    Last edited by arlu1201; 09-06-2012 at 03:15 AM.

  12. #12
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

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

    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.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  13. #13
    Registered User
    Join Date
    10-26-2011
    Location
    java
    MS-Off Ver
    Excel 2003
    Posts
    1

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

    Quote Originally Posted by VBA Noob View Post
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1