Change Number Format of textbox calculation

[dlmmrh]

Hello. I am very new to VBA so i have a question.

How do i change number format of the value for textbox total cost?

i know afterupdate but i tried and it work only on textbox that the user input data in but how do i change the number format of value that is calculated from data input by users? i want it to look like this "451,980.00" instead of just round number. same goes to value of textbox totarea and cost/m2

Thank you in advance

 

[uk747]

If the textbox is called textbox1
Maybe

Textbox1 =format(textbox1,"###,###.00")

 

[dlmmrh]

If the textbox is called textbox1
Maybe

Textbox1 =format(textbox1,"###,###.00")

ive tried this one but doesnt work. under what sub should i write this?

 

[Alex Blakenburg]

If you are in the VB editor screen does the workbook have a UserForm (in the Project window on the left) ?
Double click on that and then double click on the form (or right click and select View Code).

In the code window, I suggest you look at the Length. It already does what you are asking for, see if you can find the way that was done and apply it to the others you want done the same way.