Add A comment every time a Cell is changed in Excel VBA - Code Included

Grab the Free VBA Quick Reference Guide https://www.chrisjterrell.com/excel-v... This question came from my Youtube Channel. They wanted to add a comment ever time a cell was changed so they would know who made the change. So we use the Worksheet_Change Event, A For Next Loop, and an If ElseIf Statement (with multiple criteria) is used to solve this fun problem. Code: ======================== Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range Dim ws As Worksheet For Each c In Target If c.Comment Is Nothing And c.Value = "" Then With c.AddComment .Visible = False .Text Application.UserName & "-" & c.Value End With ElseIf Not c.Comment Is Nothing And c.Value = "" Then c.Comment.Text Application.UserName & "-" & c.Value & vbNewLine & c.Comment.Text End If Next End Sub