title: VBA Text Box displaying Currency
body: <p>I have a form with a number of text boxes for user input (this is in a User Form not on the spreadsheet). I have a few boxes that are related to currency and I need them to show the comma and decimal point as the user enters their criteria into the box. So far I have found a bunch of the same formulas online but when I input my number into the box it goes with 4.00 (if i hit 4 first) and all i can change after that is the second 0. Here is something similar I see online:</p>
  
  <pre><code>textbox1 = format(textbox1, "$#,##0.00")
  </code></pre>
  
  <p>Also seen some with cDbl</p>
  
  <p>No matter what I try it won't let me enter anything more than the first number I enter. I need help. Thanks!</p>