title: Excel VBA Copy paste into cell doesnt trigger worksheet_change
body: <p>I am trying to format a date into a fixed format everytime someone changes cell B8, entering data manually seems to trigger Macro-checkdateformat but when copy pasting into cell doesnt trigger.</p>
  
  <p>Below is my code.</p>
  
  <pre><code>Option Explicit
  
  Private Sub Worksheet_Change(ByVal Target As Range)
  
  
  If Target.Address = "$B$8" Then
  
  Call Checkdateformat
  
  End If
  
  End Sub
  </code></pre>