+ Reply to Thread
Results 1 to 16 of 16

show last modified date of a cell

  1. #1
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    show last modified date of a cell

    Dear all,
    i need a help that in my excell file how can i see the last modified date in a cell. that means if i select a cell i will see it last modified date & time.
    Dear all Expert, please help me.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: show last modified date of a cell

    You will need VBA to record the date and time any cell(or range of cells) were changed.

  3. #3
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: show last modified date of a cell

    please suggest me VBA code & procedure.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,382

    Re: show last modified date of a cell

    Thread moved to VBA section.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: show last modified date of a cell

    please help me.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,382

    Re: show last modified date of a cell

    It is only a couple of hours since you first posted and it is also a Sunday. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

  7. #7
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: show last modified date of a cell

    thanks for your kind information.

  8. #8
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: show last modified date of a cell

    Right Click on the sheet name at the bottom of excel and select view code.


    Code for a single cell

    Paste this code into the module that opens and close it.

    Please Login or Register  to view this content.
    For Multiple cells

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 08-13-2017 at 09:03 AM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  9. #9
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: show last modified date of a cell

    Dear Expert,
    Thanks a lot. really it is very helpful to me. can you add please that the comment box show me only when i select the cell.

  10. #10
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: show last modified date of a cell

    Hello
    Try this code in worksheet module
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  11. #11
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: show last modified date of a cell

    Dear Expert,
    I am not clear. please see my file and add here this action.
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: show last modified date of a cell

    Dear Expert,
    How can i use this code in a range?

  13. #13
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: show last modified date of a cell

    Dear Expert,
    i use your code for a single cell but when i insert a new row its show me runtime error. how can i avoid it?

  14. #14
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: show last modified date of a cell

    Quote Originally Posted by mehmetcik View Post
    Right Click on the sheet name at the bottom of excel and select view code.


    Code for a single cell

    Paste this code into the module that opens and close it.

    Please Login or Register  to view this content.
    For Multiple cells

    Please Login or Register  to view this content.
    Dear Expert,
    i use your code for a single cell but when i insert a new row its show me runtime error. how can i avoid it?

  15. #15
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: show last modified date of a cell

    Hi,

    Perhaps this
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  16. #16
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: show last modified date of a cell

    Thanks a lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. In a cell, show modified date for a linked document
    By KayLynne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2013, 05:01 PM
  2. Show today's date if specified cell is modified
    By xavpg in forum Excel General
    Replies: 7
    Last Post: 02-28-2012, 07:16 PM
  3. Show date last time modified
    By José Manuel Soberón in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2006, 05:10 AM
  4. Show date cell modified
    By manxman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-22-2006, 07:50 PM
  5. Replies: 0
    Last Post: 03-17-2006, 06:50 PM
  6. [SOLVED] Date last modified cell
    By Leon in forum Excel General
    Replies: 6
    Last Post: 11-26-2005, 10:15 AM
  7. Automatically show new date in the modified cell
    By NYBoy in forum Excel General
    Replies: 9
    Last Post: 10-04-2005, 11:55 AM
  8. show date modified in a cell
    By Lana in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2005, 07:06 PM

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