Good morning!
I am trying to create a userform on excel to function as a ledger. I have a text box for an amount and would like to format for currency with 2 decimal places.
Private Sub txtAmount_Change()
txtAmount.Value = Format(txtAmount, "$#,##0.00")
End Sub
It seems to be stuck to show only $#.00 (see attached). Could it be, I am supposed to do something with the txtAmount properties?
I am trying to create a userform on excel to function as a ledger. I have a text box for an amount and would like to format for currency with 2 decimal places.
Private Sub txtAmount_Change()
txtAmount.Value = Format(txtAmount, "$#,##0.00")
End Sub
It seems to be stuck to show only $#.00 (see attached). Could it be, I am supposed to do something with the txtAmount properties?