title: VBA code to set date format for a specific column as "yyyy-mm-dd"
body: <p>I have a macro which I specify the date (in mm/dd/yyyy) in a textbox and I want to set this value for column A in yyyy-mm-dd format.  I have the following code:</p>
  
  <pre><code>Sheets("Sheet1").Range("A2", "A50000").Value = TextBox3.Value
  Sheet1.Range("A2", "A50000") = Format(Date, "yyyy-mm-dd")
  </code></pre>
  
  <p>...and when I run the macro, the date is still in mm/dd/yyyy format.</p>
  
  <p>How can I change this so that it is in the format I want??  I've been trying many kinds of code researched through google and nothing will set the format the way I want it.</p>
  
  <p>Any help will be appreciated...</p>
  
  <p>EDIT: Full code from OP's comment below:</p>
  
  <pre><code> Workbooks.Add
   Range("A1") = "Acctdate"
   Range("B1") = "Ledger"
   Range("C1") = "CY"
   Range("D1") = "BusinessUnit"
   Range("E1") = "OperatingUnit"
   Range("F1") = "LOB"
   Range("G1") = "Account"
   Range("H1") = "TreatyCode"
   Range("I1") = "Amount"
   Range("J1") = "TransactionCurrency"
   Range("K1") = "USDEquivalentAmount"
   Range("L1") = "KeyCol"
   Sheets("Sheet1").Range("A2", "A50000").Value = TextBox3.Value
   Sheet1.Range("A2", "A50000").NumberFormat = "yyyy-mm-dd"
  </code></pre>