title: How to Format VBA TextBox To Long Date
body: <p>I have a textbox for date display which shows the date in this format: 17/04/2012 but I would like to format it to shows up like 'April 17, 2012'. I tried this code</p>
  
  <pre><code>UserForm1.txtDate = Format(Long Date)
  </code></pre>
  
  <p>which I am getting syntax error from compiler.Can you please let me know how I can do it?
  Thanks</p>