textbox issue

[Guest]

Can a textbox on a user form be formatted to show x decimal places as i get
5.7 ionstead of 5.70?

 

[Guest]

I have the following sub in the Form Code window (my textbox is named TxtAmt
-- so you need to change below to your textbox name accordingly...)

Private Sub TxtAmt_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
With Me.txtAmt
.Text = Format(.Text, "#,##0.00")
End With
End Sub

 

[Guest]

Thanks JMay, you gave me a start there; got it in the end.
Cheers