Easy One - Convert user text in UserForm TextBox to Currency

**DonJuan85** · 06-29-2015, 05:43 PM

Hi

I am trying to get textbox25 to automatically format the users input as £0,000 but no code that I try seems to work.

Thanks

Don

**mikerickson** · 06-29-2015, 07:00 PM

I wouldn't do that, since you have to remove the pound sign before doing any calculations. I would put a lable infront of the textbox with a pound sign in it.

If you decide to go with that approach, you could so something like

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    With TextBox1
        .Text = Format(Val(Replace(.Text, "$", vbNullString)), " $ #,##0.00")
    End With
End Sub