Number format in userform

[TheShaunMichael]

I have a userform and when you click the "Okay" command button, my spread sheet is populated with the numbers from the form but I can't get the number format correct. I've tried cell(x, y).number = so on and so forth but it doesn't work. I believe it's populating as a "General" entry in the cell.

I need the numbers in accounting format please!

At the same time, how do I add an input mask on the userform so when someone inputs a number in the textbox a comma get's added appropriately?

Thank you!

 

[TheShaunMichael]

Woops, I mean't cell(x, y).numberformat = so on and so forth

 

[Sahak]

Hi,

Try this

Private Sub CommandButton1_Click()
    Range("A1").Value = Format(TextBox1, "$#,##0.00")  'Or instead of Range("A1").Value you can use Cells(1, 1).Value
End Sub

Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    TextBox1.Value = Format(TextBox1, "#,##0.00")
End Sub