+ Reply to Thread
Results 1 to 7 of 7

How to detect row changed date and time? Is it need to write a macro?

  1. #1
    Registered User
    Join Date
    05-10-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Smile How to detect row changed date and time? Is it need to write a macro?

    Hi, everyone.

    I am a new in IT area. There is a problem to me. If there's possible to detect a changing date and time in the same row?

    For example:

    Original Copy:
    ------------------------------------------------------------------
    | A | B |
    ------------------------------------------------------------------
    | | |
    ------------------------------------------------------------------

    Once user has entered the data to the worksheet, it will auto detect the row changed time. Such as the following example:

    After modified: When i enter the B column as value 123, and the same row, column A will auto detect changed time for that row. And show out the modified date time to me, such as modified at 11:00:00 am 12th May 2010.

    ------------------------------------------------------------------
    | A | B |
    ------------------------------------------------------------------
    20100512110000| 123 |
    ------------------------------------------------------------------

    Is it need to write in macro or any excel formula can fulfill my requirement?

    Thanks for your kindly concern and help. Thanks in advance.

    Best Regards
    Cheeloon
    Last edited by cheeloont; 05-11-2010 at 11:16 PM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: How to detect row changed date and time? Is it need to write a macro?

    hello cheelont,

    welcome to the forum.

    Yes, you will need a macro. Search this forum for "time stamp" or "date stamp" and you will find many examples of how to do this. If you get stuck, post what you have and someone will help you further.

  3. #3
    Registered User
    Join Date
    05-10-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: How to detect row changed date and time? Is it need to write a macro?

    Ok thanks.

    Let me check for it. But my case is like this, now i use PHP program to generate a excel file, that works now. Before i generate the excel, i need to plug in the macro program ? Is it possible.

  4. #4
    Registered User
    Join Date
    05-10-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: How to detect row changed date and time? Is it need to write a macro?

    Sorry to bother, one more thing to ask. Macro can run in an excel all the time, no need to click the "Run" in Macro? Is it possible to do that. Because i can't ask my user to edit row and click "Run" in macro.
    Last edited by cheeloont; 05-12-2010 at 04:45 AM.

  5. #5
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: How to detect row changed date and time? Is it need to write a macro?

    cheeloont,

    I don't know anything about PHP, so whatever you need to know there, you will need to find out from PHP experts.

    This macro needs to go into the Sheet module and will insert the current date and time into column A if a value in column B is changed. Format column A to display date and time. The macro runs automatically, every time a cell in column B is changed by the user.

    See attached.

    Please Login or Register  to view this content.
    cheers
    Attached Files Attached Files
    Last edited by teylyn; 05-12-2010 at 07:14 AM.

  6. #6
    Registered User
    Join Date
    05-10-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: How to detect row changed date and time? Is it need to write a macro?

    Thanks for your powerful help teylyn.

    This example is really what I want. That is quite difficult to find a sample that i want in internet.
    I would settle the rest for myself. Too much bother to you.

    So i sincerely appreciate your help.

  7. #7
    Registered User
    Join Date
    05-10-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: How to detect row changed date and time? Is it need to write a macro?

    Thanks for your powerful help teylyn.

    This example is really what I want. That is quite difficult to find a sample that i want in internet.
    I would settle the rest for myself. Too much bother to you.

    I sincerely appreciate your help.

+ 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