title: Populate cell with the current date when spreadsheet is opened VBA
body: <p>How can I insert today's date in the cell when spreadsheet opens, so that if someone wants to change it then they can do it by changing it right within the cell.</p>
  
  <p>I have tried the following, but without much luck</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      Dim temp As String
  
      If Home.Range("_invoiceDate").Value = "" Then
          Home.Range("_invoiceDate").Value = Date
      End If
  End Sub  
  </code></pre>
  
  <p>The cell is a named range "_invoiceDate" and worksheet is "Home"</p>
  
  <p>Thanks for your help in advance</p>