Last Modified By in a cell by user

Joined
Aug 28, 2019
Messages
3
Reaction score
0
I posted this in an archived forum on accident. Posting it here as I don,t really see another thread talking about it or anything with a solution. Originally posted this on https://www.pcreview.co.uk/threads/last-modified-by-in-a-cell.987394/.

I would like to grab the user name of whoever modified a certain cell. The workbook spreadsheet would be shareable via SharePoint. Would really rather not use Track Changes.

Example:

In cell A5:
User "John S." types a string of text/ numbers.

In cell C5:
After John presses enter, C5 auto populates with his user name.

Then would then repeat on down column C.

User Susan B. then goes and grabs the workbook and types in some text/ numbers in A6 with C6 auto populating with her username. Cell C5 still shows John S modified A5.

And so on, and so on. Below is an example of what I am talking about. Right now, column B would need to be manually typed in.


1567012645718.png




There was a VB code I tried that provided a "=getLastModifiedUser()", however that was not working as it would keep returning the user actively typing in on all the cells within column B that has the formula.

Thanks!
 
Joined
Aug 28, 2019
Messages
3
Reaction score
0
Hi Francis,
Thank you for the reply. Requiring the user to log in to the worksheet probability would work but would create an additional step when the user is already logged in to their 365 account via logged into work network. Would much rather the user not have to "re log" in. I was hoping there would be some VB code that could create formula to grab the network user logged in who made a change to a cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top