cell specific "last modified by" module

[RELYT]

<code class="vb keyword">I have a spreadsheet displaying a list of "Topics to address" that people from different departments can add notes and updates to. I have a "last modified by" column and "date modified" column that i would like to merge and display the name, date, and time of the last modification to a specific cell. The two mods below are what i have now but they are updating every cell when only 1 is modified. How do i get the info I'm looking for to only populate when a specific cell is modified?

i.e Rick James 2/1/18 2:45 modified cell I3, Kenny Powers 1/28/18 5:30 modified cell I4 etc.

Appreciate any and all assistance!

Code Module 1:
Function</code> <code class="vb plain">LastAuthor()</code>

<code class="vb plain">LastAuthor = ActiveWorkbook.BuiltinDocumentProperties(</code><code class="vb string">"Last Author"</code><code class="vb plain">)</code>
<code class="vb keyword">End</code> <code class="vb keyword">Function</code>



Code Module 2:
Function LastModified() as Date
LastModified = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
End Function

Cheers!

 

[offthelip]

The best way is to use the worksheet change event,
this code shows you how to do it, I am outputing the log to column 10 but you can be more selective about what to output where and map different cells to different places

Private Sub Worksheet_Change(ByVal Target As Range)
adr = Target.Address
trow = Target.Row


LastAuthor = Application.UserName
Application.EnableEvents = False
Cells(trow, 10) = LastAuthor & " modified " & adr & " " & Now()
Application.EnableEvents = True


End Sub

 

[RELYT]

Thank you for your time and reply i really appreciate it. Forgive me for my ignorance.

I've created the module and attempted the =LastAuthor but yeilded no results. What is the function i need to use to display the data I'm looking for?

Further context of my doc.: Column D: "Topic" Column G: "Last modified by" Column I "Notes"

I'm looking for column G to populate Name, Date, Time when Column I has text added, but only for that specific row.

Thanks again!