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.
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.
You will need VBA to record the date and time any cell(or range of cells) were changed.
please suggest me VBA code & procedure.
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.
please help me.
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.
thanks for your kind information.
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.
For Multiple cellsPlease Login or Register to view this content.
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.
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.
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
Dear Expert,
I am not clear. please see my file and add here this action.
Dear Expert,
How can i use this code in a range?
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?
Hi,
Perhaps this
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks