title: change the date format in a text box
body: <p>A text box in a user form has the vba below in order to paste the date in column D on my worksheet. I need the format of the date to be pasted as follows: "YYYY/MM/DD" exactly in this order.</p>
  
  <p>However at the moment the code below pastes the date "DD/MM/YYYY". Am i missing something? thanks   </p>
  
  <pre><code>  .Cells(lRow, 4).Value = Me.txtDate.Value
    .Cells(lRow, 4).NumberFormat = "YYYY/MM/DD"
  </code></pre>