format number in textbox user form

[coolman]

Hi

I am trying to convert the value calculate in the textbox to $0.00. However it could not work.

Are there anyone who can help me?

Below is my syntax

Me.Txtboxtotalamount.Value = Me.TxtBoxQuantity * Me.TxtBoxRate
'Me.Txtboxtotalamount.Text = Format(Me.Txtboxtotalamount, "$#,##0.00")

 

[Vbagreenhorn1]

this helps?

Txtboxtotalamount.Value = Format(TxtBoxQuantity.Value * TxtBoxRate.Value, "$###,##.00")

 

[coolman]

Nope this did not work

this helps?

Txtboxtotalamount.Value = Format(TxtBoxQuantity.Value * TxtBoxRate.Value, "$###,##.00")

 

[Vbagreenhorn1]

You are posting only two lines of vba so i can't figure out which event you use to fill Txtboxtotalamount, so please provide more info (more code).

I tested the code in a button_click event and it worked...

 

[Fluff]

If you are using a Userform, then your code works for me, once you remove the apostrophe from the 2nd line