+ Reply to Thread
Results 1 to 2 of 2

Get last modified time in cell for specific value

  1. #1
    Registered User
    Join Date
    08-28-2008
    Location
    Latvia
    Posts
    21

    Get last modified time in cell for specific value

    Hello,


    As title brings, problem is simple, but I can't find solution that fits over net.

    What I would like to achive is to have in my table a column, that is updated with time stamp, when value in some other cell is changed.

    Also if possible, I would like to get a username who did it (From office or windows)


    Example

    A B C
    ------------------------------------------------------------
    15 | 2011.02.01 15:38 | Chris Madoff
    -------------------------------------------------------------

    explanation:

    15 (column A) - being the value that can change


    Columns B & C ar the dynamic ones (if value in column A changes B&C are updated)



    Anyhow, is this achivable ?


    I am using excell 2007




    Thanks for any help!



    n.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Get last modified time in cell for specific value

    Hello,
    See if this works for you....
    Please Login or Register  to view this content.
    It belongs in the worksheet module. Right click on the sheet tab and select view code,paste the code there.
    Make a change in column A to activate the code.

    Were are the modules?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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