Can someone give me a macro that will time and date stamp cell K15 upon any change within the worksheet and or workbook?
Thanks
Can someone give me a macro that will time and date stamp cell K15 upon any change within the worksheet and or workbook?
Thanks
For changes in workbook try the below. Code goes in ThisWorkbook module
http://www.contextures.com/xlvba01.html#Workbook
for sheet only try the below. Right click sheet tab > select view code > paste in the belowPlease Login or Register to view this content.
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks