Hi
I have the =now() function in a cell. I would need to change this formula to show the date and time when there is an change in the worksheet.
Hi
I have the =now() function in a cell. I would need to change this formula to show the date and time when there is an change in the worksheet.
This will require VBA and some sort of worksheet change event, I believe, so I've moved your thread to the 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.
Right Click on your sheet name at the bottom of excel and select view code.
A module will open
Paste this code into the module and close it
Please Login or Register to view this content.
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.
Hi
Thank you for your response. I tried the vba and it worked to a certain extent. I input the VBA on a file that i am working on and realised if the change on the worksheet is made due to an extraction from another tab (=another cell) the date is not changed. but if i made the change on the worksheet directly, the date and time changes. Able to assist to provide some advice please.
If change is taking place in Sheet1 from Sheet2, is it from formula?
What you are asking for is a Workbook Macro.
Select the developer tab
Select Visual Basic
Select view and then project explorer
Select your project
Double Click On This Workbook
Paste this code in the Module that opens and then close it.
Please Login or Register to view this content.
Last edited by mehmetcik; 08-22-2017 at 02:04 PM.
Hi
Doesn't seem to work. I've put a test file to show what I mean. The links are in sheet 1. The date to show should be in sheet 2 in cell I2.
Paste this for worksheet event of Sheet2
Please Login or Register to view this content.
.
Paste this macro into ThisWorkbook module :
Please Login or Register to view this content.
OMG Logit. This is an awesome macro!!
You are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks