title: Converting US(default) date format to UK
body: <p>For example:   </p>
  
  <pre><code>Sub DateFormat()
  
  Dim myDate As Date
  myDate = DateValue("12/5/2012")
  myDate1 = Format(myDate, "dd-mmm-yy")
  MsgBox (myDate1)
  
  End Sub
  </code></pre>
  
  <p>Excel VBA is following US date format, which will come out with 5-Dec-2012. I am here to ask if it is possible to add some codes, which they are meant to set the whole VBA codes relating to date to follow UK format.</p>
  
  <p>Is there any possible to localize my VBA code using my regional setting in my computer? My computer has a regional setting following UK date format.</p>
  
  <p>Thanks</p>