title: How to run VBA code when cell contents are changed via formula
body: <p>The code below works fine when I manually update column I. What I need is to know if there is a way to still have this code work when I have column I updated by a formula.</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Excel.Range)
      With Target
          If .Count &gt; 1 Then Exit Sub
  
          If Not Intersect(Range("I3:I30"), .Cells) Is Nothing Then
              Application.EnableEvents = False
              If IsEmpty(.Value) Then
                  .Offset(0, -1).ClearContents
              Else
                  With .Offset(0, -1)
                      .NumberFormat = "m/d/yy h:mm"
                      .Value = Now
                  End With
              End If
  
              Application.EnableEvents = True
          End If
      End With
  End Sub
  </code></pre>